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 Development (2000)
 error in adding a column

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2005-02-22 : 12:34:33
Hi all
please help.whenever i am trying to add a column i am getting this error.

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8063 which is greater than the allowable maximum of 8060.

how i should fix it??
Regards

Nitin

X002548
Not Just a Number

15586 Posts

Posted - 2005-02-22 : 12:42:29
A row can only have 8060 bytes....create another table with the same key...

Do you have any DDL?



Brett

8-)
Go to Top of Page
   

- Advertisement -