DW (dw*******@shaw.ca) writes:
I'd heard that the upper row limit in SQL of 6080 bytes may have been
increased with SP3.
Can anyone confirm/deny this? Is this still a 'carved-in-stone' upper
cap?
The upper limit of a row in SQL Server 2000 is 8060 bytes, and have not
changed.
In SQL 2005, you can exceed the 8060 limit, but not arbitraily. I tried
to create a table with three char(8000) columns, and that failed. But
I could create table with two sql_variant columns, and store 8000
character long strings in both on the same row.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp