row character-width limit

I recently noticed that SQL Server 2000 has an 8060-character limit on
the total row width, excluding certain field types.
I am curious if there are any newer versions of SQL server that have a
higher or no limit.
I have read this already:
http://msdn2.microsoft.com/en-us/library/ms186981.aspx
I am not interested on how to fix the problem by changing field types.
My co-workers mention an enterprise version of SQL server, but I only
notice 7.0, 2000, and 2005 mentioned on Microsoft's site and no mention
of an "Enterprise" version.
Please let me know if you have any information that might help me.
Thanks!For SQL Server 2005: "The maximum number of bytes per row is 8,060.
This restriction is relaxed for tables with varchar, nvarchar,
varbinary, or sql_variant columns that cause the total defined table
width to exceed 8,060 bytes. The lengths of each one of these columns
must still fall within the limit of 8,000 bytes, but their combined
widths may exceed the 8,060 byte limit in a table."
For a more detailed explanation, see
http://msdn2.microsoft.com/en-us/library/ms186981.aspx
Roy Harvey
Beacon Falls, CT
On 15 Jan 2007 13:36:59 -0800, "Noble Shore" <nobleshore@.gmail.com>
wrote:
>I recently noticed that SQL Server 2000 has an 8060-character limit on
>the total row width, excluding certain field types.
>I am curious if there are any newer versions of SQL server that have a
>higher or no limit.
>I have read this already:
>http://msdn2.microsoft.com/en-us/library/ms186981.aspx
>I am not interested on how to fix the problem by changing field types.
>My co-workers mention an enterprise version of SQL server, but I only
>notice 7.0, 2000, and 2005 mentioned on Microsoft's site and no mention
>of an "Enterprise" version.
>Please let me know if you have any information that might help me.
>Thanks!|||On 15 Jan 2007 13:36:59 -0800, "Noble Shore" <nobleshore@.gmail.com>
wrote:
>My co-workers mention an enterprise version of SQL server, but I only
>notice 7.0, 2000, and 2005 mentioned on Microsoft's site and no mention
>of an "Enterprise" version.
The Enterprise edition has the same row length limit. For more
information on the different editions see
http://www.microsoft.com/sql/editions/default.mspx
Roy Harvey
Beacon Falls, CT