Monday, April 16, 2007

SQL Server 2000 Row Limit?

I didn't know that SQL Server 2000 had a max row data size of something like 8K? How can this be right? Well, after one google search, I have found the answer. The limitation is 8060 Bytes for each insert, but you can update each column separately. Also, if you use a text field or an image field, you are safe. Reference and here too.

No comments: