Collation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Collation

Collation

Rate Topic

Display Mode

Topic Options

Author

Message

Vinesh-489191

Posted Wednesday, November 12, 2008 8:02 AM

Forum 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

The_SQL_DBA

Posted Wednesday, November 12, 2008 11:34 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:06 PM
Points: 794, Visits: 902

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 »

Permissions