Can some body tell abt this warnings

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Can some body tell abt this warnings

Author

Topic

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2007-04-10 : 00:53:18

Hi

Warning: The table 'Table1' has been created but its maximum row size (13559) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Warning: The table 'Table2' has been created but its maximum row size (12125) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Warning: The table 'Table3' has been created but its maximum row size (12114) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Warning: The table 'Table4' has been created but its maximum row size (9329) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Warning: The table 'Table5' has been created but its maximum row size (12125) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Warning: The table 'Table16' has been created but its maximum row size (12114) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Thanks in Advance

SreenivasaRao
Bangalore,INDIA

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-10 : 01:01:41

You have altered or created a table where the sum of the column sizes exceed 8060 bytes.

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-10 : 01:33:44

Isn't that obvious?

Cause and effect is nicely explained in the warning message itself. What more do you expect from SQL Server?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-10 : 01:57:42

perhaps OP is wondering why such a limit exists.

it's because 8k is the size of a data page in sql server. 8060 bytes is what's left over for data after various per-page overhead is taken into account.

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources