sql server (alternate): Question: Upper row limit of 6080 characters -- sql server (alternate)

Question: Upper row limit of 6080 characters

DW
2/21/2005 2:45:14 PM

sql server (alternate): Hi, all:

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?

Thanks,

DW.

Re: Question: Upper row limit of 6080 characters

Erland Sommarskog
2/21/2005 11:30:22 PM

DW (dwhittier@shaw.ca) writes:
[quoted text, click to view]

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, esquel@sommarskog.se

Books Online for SQL Server SP3 at