I'm pretty new to SQL, so excuse me for landing in this situation in the first place. Never again!
I had an old Windows 2003/SQL 2000 server which I wanted to retire, so installed a nice new Windows 2008 R2/SQL 2008 server to host all the databases. I detached all the databases, copied them over, and attached them to the new server. Everything
appeared to be running OK. However, the application is now complaining that I have different collations between the master database, and all the other ones. the master (and other system databases) is Latin1_General_CI_AS and all the user ones are
What I need to do is change the master to SQL_Latin1_General_CP1_CI_AS and ensure that any new databases which the application creates in future are also SQL_Latin1_General_CP1_CI_AS. I have no idea how to do this!
I suppose one option wiould be to reinstall and start again, but I'm sure there must be an easier way. Musn't there? Help!
View Complete Post