Tody, I created a table with three columns are of data type varchar(8000), and a warning was prompted out in the SQL Query Analyzer: “Warning: The table 'TestTable' has been created but its maximum row size (24094) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row will fail if the resulting row length exceeds 8060 bytes.”.
This means a table row has its maximum capacity, and in SQL Server 2000, the maximum capacity is 8060 bytes. The reason of this limitation is that the size of storage pages SQL Server used to store data is 8k, and the capacity of a row can not exceed that page size. So take care of this limitation. And if you want to store large characater or binary data, use text, ntext, or image.
This means a table row has its maximum capacity, and in SQL Server 2000, the maximum capacity is 8060 bytes. The reason of this limitation is that the size of storage pages SQL Server used to store data is 8k, and the capacity of a row can not exceed that page size. So take care of this limitation. And if you want to store large characater or binary data, use text, ntext, or image.
There are also other maximum capacity specifications in SQL Server 2000. For more detailed information see:
http://www.cnblogs.com/laser_lu/articles/44656.aspx