November 1, 2007 at 6:54 am
Afternoon
Is it possible to change the collation on a Server from a SQL Collation to a Windows Collation without reinstalling SQL Server from scratch?
Gary
November 1, 2007 at 11:40 pm
Possibly no. You need to reinstall the server with the right collation.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 2, 2007 at 10:28 am
Regarding SQL2K: it is a bit complicated but you don't have to reinstall from scratch. To change default collation you do need to Rebuild the master and reattach all the user databases. I guess they will retain their own collations unless you change them individually too.
In BOL, see collations >> changing settings. But check out MSDN and Google Groups for easy step-by-steps, and help identifying which collation means what.
And there's a gothcha with SQL2K - the source for x86\DATA must not be Read-only: http://support.microsoft.com/kb/273572
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply