修改排序规则

ALTER DATABASE DB SET SINGLE_USER WITH ROLLBACK IMMEDIATE --修改为单用户


CREATE DATABASE DB COLLATE Chinese_PRC_CI_AS --创建数据库指定规则
GO
ALTER DATABASE DB COLLATE Chinese_PRC_CI_AS  --修改排序规则
GO

SELECT
SERVERPROPERTY('ProductVersion ') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ResourceVersion') AS ResourceVersion,
SERVERPROPERTY('ResourceLastUpdateDateTime') AS ResourceLastUpdateDateTime,
SERVERPROPERTY('Collation') AS Collation;




ALTER DATABASE DB SET MULTI_USER  --多用户