Monday, September 2, 2013

How to end / kill all transaction for sepecif database


USE master;
GO
ALTER DATABASE databaseName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
ALTER DATABASE databaseName
SET MULTI_USER;
GO

Kill single user
exec sp_dboption 'DatabaseName', 'single user', 'FALSE'