InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:08:56 GMT20http://www.sqlservercentral.com/Forums/Topic601409-146-1.aspxServer collation change calls for re-installation.Instead change DB collation as ALTER DATABASE MyDatabase COLLATE Watch out if you use temporary tables a lot and do joins to your databases.. temp tables are created in tempdb which always has the server default collation so if you are joining temp tables to your db tables you can get collation conflicts.. i.e. the server default does matter sometimes . You may want to check out this link to change the collation.[b][url]http://www.databasejournal.com/features/mssql/article.php/3302341[/url][/b]You can change the collation for a database or column level in SQL 2000 by using alter statements. You do not need to rebuild the master database.Wed, 12 Nov 2008 11:34:06 GMTThe_SQL_DBAhttp://www.sqlservercentral.com/Forums/Topic601409-146-1.aspxHi Alli've installed sql 2005 with the incorrect collation,(on 3 Different servers) is there a way , other than reinstalling sql to change the language safely and without underline problems laterThank youWed, 12 Nov 2008 08:02:00 GMTVinesh-489191