SQL server 单用户切换成多用户

--杀死占用进程

declare @spid int ;

declare @ddlstring nvarchar(max);

declare @dbname varchar(200);

set @dbname='MES_8_5_5_HYT_Prod'; --数据库名

declare tmpcur cursor

for select distinct spid as spid from sys.sysprocesses

where dbid=db_id(@dbname) ;

OPEN tmpcur;

fetch tmpcur into @spid ;

while (@@FETCH_STATUS=0)

begin

  set @ddlstring=N'Kill '+CONVERT( nvarchar,@spid) ;

  execute sp_executesql @ddlstring ;

  fetch tmpcur into @spid ;

end ;

close tmpcur ;

deallocate tmpcur ;

--设置属性为多用户

ALTER DATABASE MES_8_5_5_HYT_Prod SET MULTI_USER