修改为区分大小写
ALTER DATABASE 数据库名 COLLATE Chinese_PRC_CS_AS
修改为不区分大小写
在执行t-sql之前先把企业分析器关掉
use master
declare @dbname varchar(20)
set @dbname='zxj_xinchengxu1'
declare @sql nvarchar(500)
declare @spid int
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status < >-1
begin
exec('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
ALTER DATABASE zxj_xinchengxu1 COLLATE Chinese_PRC_CI_AS