Index size problem

I am copying our progress database over to our Sql Server 2000 system.
I found a problem with the index size being too large. The description
is 2000 bytes and Sql Server is giving me an error saying I have
exceeded the index size of 900 bytes.
Is there a way around this?
Thanks,
Tom.
i assume you're trying to index a description column that's a
varchar(2000). if so, don't index it. there's probably no good reason to
index that column.
Thomas Scheiderich wrote:

> I am copying our progress database over to our Sql Server 2000 system.
> I found a problem with the index size being too large. The description
> is 2000 bytes and Sql Server is giving me an error saying I have
> exceeded the index size of 900 bytes.
> Is there a way around this?
> Thanks,
> Tom.
|||No. At least not without changing the data type to less than 901 bytes.
Gert-Jan
Thomas Scheiderich wrote:
> I am copying our progress database over to our Sql Server 2000 system.
> I found a problem with the index size being too large. The description
> is 2000 bytes and Sql Server is giving me an error saying I have
> exceeded the index size of 900 bytes.
> Is there a way around this?
> Thanks,
> Tom.
(Please reply only to the newsgroup)