Posts
808
Comments
670
Trackbacks
1
T-SQL: "exceeds the maximum number of bytes per row (8060)"

“exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.”

This message occurs when the sum of the bytes of the data types of all the columns in a table exceeds the limit that SQL Server allows.  The only real solution for this is to break up the table into multiple tables.

posted on Wednesday, April 13, 2005 12:28 PM
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 8 and 8 and type the answer here: