469,106 Members | 2,224 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Question: Upper row limit of 6080 characters

DW
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.

Jul 23 '05 #1
1 1299
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by CajunCoiler \(http://www.cajuncoiler.tk\) | last post: by
24 posts views Thread by arcticool | last post: by
10 posts views Thread by garyusenet | last post: by
5 posts views Thread by =?Utf-8?B?cmtibmFpcg==?= | last post: by
1 post views Thread by =?Utf-8?B?SmVzcGVyLCBEZW5tYXJr?= | last post: by
sfsustudent
4 posts views Thread by sfsustudent | last post: by
16 posts views Thread by Chad | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.