November 1, 2007 at 9:58 am
Hi.
I am running a DTS process which fails on a pearticular step with the following message:
"The index entry of length
1209 bytes for the index exceeds the maximum length of 900 bytes"
Can anyone suggest what i need to do to resolve this.
Thanks.
November 1, 2007 at 10:04 am
Have a look at this index. Most likely it will have a few variable length columns in it. There is a limit to index entry sizes, and it can be exceeded at runtime if you add a variable column with a large value.
You will need to check if this column that contains the long data is correct (or the long data is inserted erroneously). If it is correct, you may want to change the index.
Regards,
Andras
November 1, 2007 at 2:37 pm
You got to check BOL for maximum limit under "Data Types" "CREATE INDEX" "Creating an Index"
November 1, 2007 at 3:01 pm
The length on the column was 2000. I deleted the index and recreated a new on with column size 1800. Do not know if it will work. Trying to understand what the relationship is between column size and index.
November 1, 2007 at 9:50 pm
Well the insert/update will fail if the total length is greater than 900. So in your case this will fail again since you created it on a column with length 1800.
So you will have to drop this index and create an index so that the total length does not exceeds 900.
November 1, 2007 at 11:21 pm
The column that holds the index should not have a size more then 900. The best option is to create an index in clumns that are smaller in length, 95% unique, etc. You need to have the column length set to less than 900 so you will not get an error @ runtime.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply