Posted By

timshingyu on 12/11/09


Tagged

mssql


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Change SQL server DB collation name


 / Published in: SQL
 

  1. ALTER DATABASE [DATABASE] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  2. ALTER DATABASE [DATABASE] COLLATE [collation_name]
  3. ALTER DATABASE [DATABASE]SET MULTI_USER

Report this snippet  

You need to login to post a comment.