Aamir Khan

Aamir Khan

  • NA
  • 273
  • 311k

Warning While Adding a New Field in Sql Server 2000 Database Table

May 9 2012 7:15 AM

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



Answers (5)