What's the maximum size of a row?
Deepak Agrawal
Row size in SQL server is upto 8096 bytes.
If you want check this practically then please do the following steps.
1) Create table abc with field name "Field1" with datatype ntext.
2) Insert lot of data into that table abc
3) Create Insert SQL Script of that added row.
4) Create one another table xyz
5) Modify the Insert SQL Script with New table.
4) Run that script you will get the following warning.
Warning: The table 'xyz' has been created but its maximum row size (10541) 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.