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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2008-02-04 : 23:22:52
|
| Hi,I found this error while reviewing my logs. I'm not very good with indexes, and the indexes I am using have been generated from the sql wizard. I'm not getting this error on everyquery, just randomly. Is this cause for concern? Why would some queries fail but others not? Thanks for any assistance!much appreciated,mike123 Exception information: Exception type: SqlException Exception message: Operation failed. The index entry of length 996 bytes for the index 'tblInstantMessage25' exceeds the maximum length of 900 bytes. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-04 : 23:42:52
|
| What are the data types and sizes for the columns in your tblInstantMessage25 index? As noted by the error, it can't exceed 900 bytes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-07 : 03:49:31
|
Unless you are using SQL Server 2005.Then you can use the INCLUDE keyword when creating indexes.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-25 : 09:09:22
|
Show us the table DDL and your code for creating the index.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
help with exception message (index too small)