Exceed the maximum number of bytes per row.

Exceed the maximum number of bytes per row.

Post by Jong-Yun Moo » Fri, 21 Aug 1998 04:00:00



Dears

  I'm using MS SQL 6.5 with Service Pack 4.

   For getting data at just one HTML page, I created many columns on the
table "mjl_applicant". When I create constraint, I got the following message
saying  "The total row size, 2144, for table 'mjl_applicant' exceeds the
maximum number of bytes per row, 1962."

  Even it shows warning, there is no problem in inserting & querying data.
Might there be some problems in the future?

Thanks in Advance

 
 
 

Exceed the maximum number of bytes per row.

Post by Tony Rogerso » Fri, 21 Aug 1998 04:00:00


It means the structure of the table has the potential of a maximum row size
of 2144, this is probably because you have a lot of var... fields varchar,
varbinary.... These fields only take up space for what they currently hold,
unlike fixed length fields like char not null.

--
Tony Rogerson
Torver Computer Consultants Ltd.

begin 666 Tony Rogerson.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E)O9V5R<V]N.U1O;GD-"D9.


M3U1%1"U04DE.5$%"3$4Z.SM4;W)V97(],$0],$$R-B!-;V]R;&%N9"!2;V%D
M.TAA<G!E;F1E;CM(97)T9F]R9'-H:7)E.T%,-2 T3$$[16YG;&%N9 T*3$%"
M14P[5T]22SM%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.E1O<G9E<CTP1#TP
M03(V($UO;W)L86YD(%)O860],$0],$%(87)P96YD96XL($AE<G1F;W)D<VAI

M150Z=&]N>7)O9V5R<V]N0&-O;7!U<V5R=F4N8V]M#0I2158Z,3DY.# X,C!4

`
end

 
 
 

Exceed the maximum number of bytes per row.

Post by Alois Stol » Sat, 22 Aug 1998 04:00:00


SQl Server permits max. 1962 bytes per row (without regarding text and Image
columns)