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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2010-12-28 : 13:52:06
|
| I got the below error..How should i correct itWarning! The maximum key length is 900 bytes. The index 'IDX_table_columnname' has maximum length of 7000 bytes. For some combination of large values, the insert/update operation will fail.Please suggest |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-12-28 : 13:57:36
|
| I assume you're creating an index. Look at the INCLUDE statementJimEveryday I learn something that somebody else already knew |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2010-12-28 : 14:56:48
|
| I am creating the non clustered index on the column of the table which has columname nvarchar(7000)...Below is my query..CREATE INDEX IDX_Tablename_Columnname ON Database.dbo.Tablename (Columnname) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2010-12-28 : 15:43:18
|
| Thanks for reply..What is the alternative solution to avoid the insert or update command that exceeds 900 bytes fail.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2010-12-28 : 23:53:14
|
| Can you guide me about fulltext search.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Script