Very Computer

by **malcol** » Sat, 08 Sep 2001 17:02:03

I need to change the sort order of a database to case
insensitive, currently case sensitive.

has anyone any ideas on how to do this without
reinstalling sql server 7 sp3

cheers

malcolm

by **Simon Lidber** » Sat, 08 Sep 2001 17:53:01

That is unfortunately not possible. You need to extract your data using
either bcp or DTS then you need to rebuild your server create the database
and import the data again.

If you are using SQL 2000 you would be able to do it without
reinstalling/rebuilding.

Best Regards
Simon Lidberg
Microsoft Sweden

Quote:> I need to change the sort order of a database to case
> insensitive, currently case sensitive.

> has anyone any ideas on how to do this without
> reinstalling sql server 7 sp3

> cheers

> malcolm

by **malcol** » Sat, 08 Sep 2001 19:38:29

Hi I believe it is possible following

Sql books online use index tab
search for sort order
select modifying
follow these instructions and you can modify the case
sensitivity of the master dbase
One of the main drawbacks is that the security logons are
deleted and you have to recreate them.

However you can write a script to do this

What do you think

Malcolm

>-----Original Message-----
>That is unfortunately not possible. You need to extract
your data using
>either bcp or DTS then you need to rebuild your server
create the database
>and import the data again.

>If you are using SQL 2000 you would be able to do it
without
>reinstalling/rebuilding.

>Best Regards
>Simon Lidberg
>Microsoft Sweden

in message

>> I need to change the sort order of a database to case
>> insensitive, currently case sensitive.

>> has anyone any ideas on how to do this without
>> reinstalling sql server 7 sp3

>> cheers

>> malcolm

>.