I need to change the collation sequence for SQL 2K5.
I mistakenly used a collation sequence for backward compatibility when installing, instead of choosing the case sensitive order I wanted. Of course, I didn't notice it until afterwards.

Does anyone know how I can change it without re-installing everything?

Thanks in advance,
Karen

You can only change the server collation by issuing a reinstall. Review the BOL... ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3242deef-6f5f-4051-a121-36b3b4da851d.htm

If you don't mind the system databases and the server default having the 'unwanted' collation, you can always created each new database with a different collation than the server default.

HTH


Adam Gossage
Lake Wylie, SC, USA

Thanks.
I found the article after I had posted.
I went ahead and did the reinstall, so I don't have to remember later.

Karen