It was the statistics, I dropped that particular statistics and I was able
to change the size of the column.
Thanks, you saved me a lot of time on this.
>That column in question is not used in Foreign Keys. When I do a
>sp_helpindex there is a statistics set up on that column,
>_WA_Sys_namecomm_2EDAF651. Could it be causing the problem?
>I will drop the statistics and see if I can do the alter table with no
>error....
>Thanks
>>Michaele,
>>A few guesses:
>>What does sp_helpindex tblname say?
>>Any statistics?
>>Foreign key?
>>--
>>Tibor Karaszi, Cornerstone Sweden AB
>>MCDBA, MCSE, MCSD, MCT, SQL Server MVP
>>Please reply to the newsgroup only, not by email.
>>> We are changing some column sizes in our database using the Alter table
>>> statement. We have one table at one of our client sites getting the
>>> following error:
>>> 1903 - 37000 - [Microsoft][ODBC SQL Server Driver][SQL Server]900 is the
>>> maximum allowable size of an index. The composite index specified is
4000
>>> bytes.
>>> Even if I drop off all of the indexes I get this error. Are there
hidden
>>> indexes in SQL 7.0? Anybody have an idea on this one? The column being
>>> changed is not part of any index I can see.
>>> Thanks!
>>> Michaele James
>>> JSI FundRaising Systems
by