Maximum Row Size of a Table in SQL Server

Question

What is the maximum row size of the table in sql server 2008?

Ans

8060 bytes

Following is the error message displayed-

Msg 511, Level 16, State 1, Line 1Cannot create a row of size 8218 which is greater than the allowable maximum row size of 8060 bytes.
 

Ebook Download
View all
Learn
View all