-
Total row size in a table
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
-
Total row size in a table (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|