Dear Friends,
I am facing a Warning Message in sql server 2000, while Adding 2 Fields by using
Alter Query.
My Query:
1)alter table Receipt_Detail_New
add BillingName varchar(100)
it shows me the Following Message:Warning The table 'Receipt_Detail_New' has been created but its maximum row size (9886) 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.
2)alter table RECEIPT_PAYMENT
add BillingName varchar(100)
it shows me the Following Message:Warning: The table 'RECEIPT_PAYMENT' has been created but its maximum row size (11121) 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.
what could be done in such Cases
Please Reply.
Thanks & Regards,
Aamir
Loading
Aamir KhanPosted May 9, 2012, 2:57 PM
SenthilkumarPosted May 9, 2012, 9:13 AM
I do not think, you have any solution to fix this in sql server 2000. But you can overcome in 2005 by set the maximum length to the columns.
All you need to do is suppress the column size by setting less than 8060 bytes.
For related info:
http://www.mssqltips.com/sqlservertip/2242/row-sizes-exceeding-8060-bytes-in-sql-2005/
VulpesPosted May 9, 2012, 8:36 AM
Aamir KhanPosted May 9, 2012, 8:20 AM
SenthilkumarPosted May 9, 2012, 7:41 AM
The reason, sql server provides limit to the each row in sql server table.
Here it is calculated based on the size you defined each column. But while inserting data into the rows, if size may be less or more. then you will get actual error.