Total row size in a table

[Zoey]

Hi,
I am getting this error when I try to run a script to create a table. The error reads as below

The total row size (12488) for table exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.

Can somebody tell me what I have done wrong?
thanks
zoey

[Markus]

Hi Zoey,

like the message says, the maximum rowsize in SQL Server 7.0 or 2000 is 8060 bytes and if you want to use merge replication it's even less (6000). So you need to change the design by breaking up your table in two. Check also your datatypes for not wasting space (use varchar instead of char etc.)

Check also this article
http://www.sql-server-performance.com/nb_saving_space.asp

Markus


------------
Zoey at 6/18/01 4:45:19 PM


Hi,
I am getting this error when I try to run a script to create a table. The error reads as below

The total row size (12488) for table exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.

Can somebody tell me what I have done wrong?
thanks
zoey