November 12, 2008 at 8:02 am
Hi All
i'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 later
Thank you
November 12, 2008 at 11:34 am
Server 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.
http://www.databasejournal.com/features/mssql/article.php/3302341
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.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply