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.
| Author |
Topic |
|
rajasanjeevkumar
Starting Member
1 Post |
 Posted - 2008-08-08 : 11:14:13
|
| I have an xml schema validating a column in a table. This schema has grown over time. Last time, when I applied the new bigger schema, I got this error. Cannot create a row of size 8063 which is greater than the allowable maximum of 8060.What is the best way to redesign my database?Any help will be appreciated.Thanks. |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-08-22 : 22:39:21
|
| Ive seen this error as well and I cannot find the MS link that detailed it.It may have to do with continually issuing ALTER table statements against a table. There is some indirect limit on the number of times a table can be altered. You can workaround by rebuilding the clustered index on the offending table which reclaims the page space. Please let me know if that works for you.Nathan Skerl |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
|
|
|
XML Column