Hi everyone,

I have a Oracle database application which has an index on
varchar2(2000). Now I am moving the database to Sql Server
and facing index limitation problem. Sql Server only allow
you to build index on column which has less than 900 bytes.

Is there anyway in Sql Server to build index on a column
with more than 900 bytes ?


Thanks in advance.

Ming,
This type of question would be better posted in the
microsoft.public.sqlserver.programming than in the fulltext newsgroup.
Either way, the restriction is there in SQL Server 2000, see BOL title
"Maximum Size of Index Keys". Is there any other existing column you could
use as the primary key? or any other combination of columns that could be
used? If not, then you will need to add additional columns to build your
index on that total less than 900 bytes :-(

Regards,
John


[quoted text, click to view]