Need help changing SQL Server Collation.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Need help changing SQL Server Collation.

Author

Topic

NguyenL71
Posting Yak Master

228 Posts

Posted - 2012-02-02 : 16:41:43

[code]Hi,

Our application works only with below SQL Server collation but someone else installed default collation. Is
there a way to change a collation without re-installing SQL Server. I need to change to the correct collation
blow. Any helps greatly appreciate. I am using SQL Server 2008.

Server Collation: Latin1_General_CI_AS

Thank you.[/code]

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-02 : 16:50:12

Please see this and this

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-02 : 19:41:51

quote:

Originally posted by NguyenL71

Hi,

Our application works only with below SQL Server collation but someone else installed default collation.  Is
there a way to change a collation without re-installing SQL Server.  I need to change to the correct collation
blow.  Any helps greatly appreciate.   I am using SQL Server 2008.

Server Collation: Latin1_General_CI_AS

Thank you.

you can change it
however if database already has tables with other collation data it will still as it is
collation change only gets applied to new objects

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources