Quick Contact

Kill all active connections on DB

The sql to kill the active database connections  

 

declare @execSql varchar(1000), @databaseName varchar(100)  
-- Set the database name for which to kill the connections  
set @databaseName = 'myDatabase'  
  
set @execSql = ''   
select  @execSql = @execSql + 'kill ' + convert(char(10), spid) + ' '  
from    master.dbo.sysprocesses  
where   db_name(dbid) = @databaseName  
     and  
     DBID <> 0  
     and  
     spid <> @@spid  
exec(@execSql)"
Additional Articles
X

Partners

© 2013 XGlobe Online Ltd.