We made mistake when we installed SQL Server 2008 with wrong collation.
I know it's n't recommended to change the Collation on server level,But What is the opinion of the experts on this site it's recommended to change the collation on the server level ? and what is the best way to do that?
As recommend by Microsoft, http://msdn.microsoft.com/en-us/library/ms179254(v=sql.105).aspx, I think that I would either
a) Reinstall with the correct Collation
b) Change the collation of the new databases.
Given that option 'B' I think would get confusing and most likely a database would be missed and cause havoc later in life, I would most likely opt for a complete reinstall. Do you already have user databases on the server and is it in production?
Just my opinion though.
answered Dec 10 '12 at 03:04 AM
Seriously, go for the re-install option. Collation issues are a major ball-ache for an incoming DBA, so much so that I contributed a test in @Brent Ozar's sp_Blitz - http://www.brentozar.com/blitz/ - http://www.brentozar.com/blitz/database-server-collation-mismatch/
answered Dec 10 '12 at 02:25 PM
Reinstalling with correct collation is the only solution check the below link http://sqlbuzz.wordpress.com/2011/08/20/how-to-rebuild-master-database-aka-rebuilding-sql-server-2008r2/
answered Dec 10 '12 at 05:50 AM