Code Snippet posted by:
Kapildalke | Posted on: 5/26/2012 | Category:
SQL Server Codes | Views: 1451 | Status:
[Member] |
Points: 40
|
Alert Moderator
This query should be executed in Master Database(System Database)...
select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = 'db_Name'
GO
kill sp_id
exec sp_dboption 'db_Name', 'single user', 'FALSE'
Found interesting? Add this to: