Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Collation Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 8:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 30, 2010 12:33 AM
Points: 6, Visits: 61
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
Post #601409
Posted Wednesday, November 12, 2008 11:34 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 14, 2014 3:15 PM
Points: 804, Visits: 935
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."
Post #601593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse