Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Row size
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Miscellaneous
Thread ID:
01011800
Message ID:
01011814
Views:
15
Mahmood,

are you trying something like this?
create table #test1 ( c1 char(4000), c2 char(4000), c3 char(4000) )
You'll get this error in SQLServer2000:

Server: Msg 1701, Level 16, State 2, Line 1
Creation of table '#test1' failed because the row size would be 12021, including internal overhead. This exceeds the maximum allowable table row size, 8060.

Look at the BOL topic for CREATE TABLE:

SQL Server can have as many as two billion tables per database and 1,024 columns per table. The number of rows and total size of the table are limited only by the available storage. The maximum number of bytes per row is 8,060. If you create tables with varchar, nvarchar, or varbinary columns in which the total defined width exceeds 8,060 bytes, the table is created, but a warning message appears. Trying to insert more than 8,060 bytes into such a row or to update a row so that its total row size exceeds 8,060 produces an error message and the statement fails.

> I get an error when I execute my sql statement. I am not sure how to fix it. Any help is appricated.
>
>Error:
> The table 'Meeting' has been created but its maximum row size (8083) exceeds the maximum number of bytes per row (8060). ...
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform