SQL SERVER变更数据库的“排序方式”

--有人在用数据库嘛.   关了它,或者用下面的存储过程强制关闭 

/* 

断开所有用户打开的连接 

*/ 

use master 

go 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 

drop procedure [dbo].[p_killspid] 

GO 

create proc p_killspid 

    @dbname sysname --要关闭进程的数据库名 

as 

declare hCForEach cursor for 

 select s= 'kill ' + cast(spid as varchar) 

 from master..sysprocesses   

 where dbid=db_id(@dbname) 

EXEC sp_MSforeach_Worker @command1=N'?' 

go 

--关闭用户连接 

exec p_killspid 'YourDBName' 

go 

exec sp_dbcmptlevel 'YourDBName',80       --修改数据库的兼容级别 

go 

alter database releaseDBStd collate Chinese_PRC_CI_AI --修改排序规则为不区分大小写 

go