停掉數據庫進程

停掉數據庫進程

＝＝＝

declare @kill varchar(2000);
set @kill = '';
select @kill = @kill + 'kill ' + rtrim(spid) + ';'
  from master..sysprocesses
 where dbid = DB_ID('dbschema') and hostname <>'xx-PC';
print @kill;
exec (@kill);