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 = 'databasename'
go
kill 64
go
EXEC sp_dboption 'databasename', 'single user', 'false'
Monday, September 20, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment