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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-05 : 21:29:31
|
| Anastasia writes "Dear people,We have a table that has only nonclustered indexes.It has column pricing_note varchar(255)When I apply this script to T_company-- -- --ALTER TABLE T_COMPANY ALTER COLUMN pricing_note varchar(1000) NOT NULLGO-- -- --I get this message:Server: Msg 1903, Level 16, State 1, Line 1900 is the maximum allowable size of an index. The composite index specified is 1000 bytes.Please explain why this message is happening and how can I fix it or determinewhat causes the problem.Thank you.Anastasia" |
|
|
|
|
|
phantom index