April 20, 2009 at 10:13 am
A new sql2k5 instance was installed at my company with the collation Latin1_General_CI_AS when it should have been SQL_Latin1_General_CP1_CI_AS to match the user databases. This is causing some collation issues and I need to change the collation on master, msdb, tempdb and model to be SQL_Latin1_General_CP1_CI_AS. Is there a straight-forward way to do this?
I have googled around and searched these forums but not come up with anything concrete.
Thanks in advance for any help.
April 20, 2009 at 10:24 am
Per Microsoft you must rebuild the Master check below for all you need.
http://support.microsoft.com/kb/325335
Kind regards,
Gift Peddie
April 20, 2009 at 2:21 pm
I had to go trough the painful task of updating the Collation.
Here's the command I used:
start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD= SQLCOLLATION=
This will rebuild the master databases. You will need to make sure you can then reattach/restore your databses, jobs, etc....
April 20, 2009 at 4:27 pm
As said, it's quite painful. You'd be better off to do a re-install if possible.
April 21, 2009 at 2:12 am
I think I might go the reinstall route then. The server is not yet in production so this isn't a problem. Just a bit of a pain as I had done a fair bit of setup work on it.
Cheers for the advice everyone.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply