Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Row size
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Divers
Thread ID:
01011800
Message ID:
01011814
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform