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'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment