Dienstag, 21. Februar 2012

How to change the collation of an SQL Server Database

ALTER database DBNAME set Single_User with Rollback Immediate
GO
ALTER DATABASE DBNAME COLLATE NEW_COLLATE --Latin1_General_CI_AS
GO
ALTER DATABASE DBNAME set multi_user
GO

1 Kommentar:

  1. Casino Spadex | Shooting Sports Casino in Las Vegas, Nevada
    a Vegas 더킹카지노 Strip hotel-casino featuring a casino. Featuring a pool, 바카라 pool, restaurants, bars, and so 샌즈카지노 much more!

    AntwortenLöschen