tag:blogger.com,1999:blog-74195026209555333682024-10-25T13:34:20.716+02:00Micha's BlogUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7419502620955533368.post-48101433496650022782012-02-21T15:29:00.001+01:002012-02-22T12:28:38.006+01:00How to change the collation of an SQL Server DatabaseALTER database DBNAME set Single_User with Rollback Immediate<br />
GO<br />
ALTER DATABASE DBNAME COLLATE NEW_COLLATE --Latin1_General_CI_AS<br />
GO<br />
ALTER DATABASE DBNAME set multi_user<br />
GOUnknownnoreply@blogger.com3