SQL Server中，杀掉访问某数据库的所有连接

use master
GO

declare @dbname varchar(50)
declare @script varchar(8000)

set @dbname='Your_DB_Name'
set @script=''

select @script=@script+' kill '+cast(spid as varchar(8))
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = @dbname

if @script<>''
    exec(@script)
else
    print 'No process found'