abhisheksharmacnn (3/6/2013)
I am getting following error while creating indexError/Warning Message is :-
Warning! The maximum key length is 900 bytes. The index 'IDX_TERMX' has maximum length of 8000 bytes. For some combination of large values, the insert/update operation will fail.
Msg 1946, Level 16, State 3, Line 3
Operation failed. The index entry of length 904 bytes for the index 'IDX_TERMX' exceeds the maximum length of 900 bytes.
The statement has been terminated.
Please let me know if there is any resolution.
Simple, modify the columns used in the index such that the total max length of all the columns is less than or equal to 900 bytes.
SQL Server has a hard limit of 900 bytes for the size of an index.