asp.net codes
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'
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)