header image
 

How to kill all connected users to SQL DB

Aaquagua!: Kill All Database Connections to a SQL Server Database

alter database AURORA set single_user with rollback immediate ;
GO
alter database AURORA set multi_user with rollback immediate ;
GO

sp_who

~ by shoel on March 25, 2009 .



Leave a Reply