Change SQL database collation

SQL database can be changed by using this sql script

ALTER DATABASE UnuScriptTest SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE UnuScriptTest COLLATE Latin1_General_CI_AS;
GO

ALTER DATABASE UnuScriptTest SET MULTI_USER;

GO
Advertisements