advanced code snippet search

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
 
Expand | Embed | Plain Text 
  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.