Change Collation of a DB - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Change Collation of a DB

Author

Topic

gercr
Yak Posting Veteran

53 Posts

Posted - 2002-10-14 : 11:38:23

Hi is possible to change the collation of a DB ???

ashok
Yak Posting Veteran

57 Posts

Posted - 2002-10-14 : 12:13:43

yu can change the default collation order for the
db :


ALTER DATABASE dbname COLLATE collation_order

-ashok
http://www.unganisha.org

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-10-14 : 17:29:02

Be sure to read the BOL entry for ALTER DATABASE before you do this because there's a nice long list of caveats that starts out with Before you apply a different or new collation to a database, ensure the following conditions are in place:

Also, this only applies to SQL 2000. If you're on SQL 7, the collation applies to the entire server, not individual DB's. To change that requires rebuilding master.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources