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 2005 Forums
 SQL Server Administration (2005)
 Please Help Me ...

Author  Topic 

skiski
Starting Member

15 Posts

Posted - 2010-05-27 : 03:06:13
SQL version 2000

The index entry of length 909 bytes for the index "IX_tbl_DocumentsRowDesc" exceeds the maximum length of 900 bytes.

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-27 : 04:07:31
The maximum size of an index key is 900 bytes. Yours is too wide. Remove some columns from the index key.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -