default collation

hello,
how can I change the default collation (case-sensitive --> case-insentive)
of my instance?
regards,
uwe
I'm fairly sure you must reload the data.
http://support.microsoft.com/default...&Product=sql2k
Look for the section titled:
"Transfer a database from one collation in SQL Server 2000 to a different
collation in SQL Server 2000"
According to this article, the task is more difficult if the columns have
explicit collation (and I believe that's going to be the case even if the
column collation matches the database collation).
This process can be time-consuming. If your database is large, don't run
the copy process on your own workstation. Use WTS to do this or schedule a
job on the database server, so you don't copy all the bits over the network
to your PC and then back to the server.
"Uwe Muench" <uwe.muench@.fh-furtwangen.de> wrote in message
news:newscache$h1wjvh$w4m$1@.news.ghb.fh-furtwangen.de...
> hello,
> how can I change the default collation (case-sensitive --> case-insentive)
> of my instance?
> regards,
> uwe
>