exec sp_dboption 'epicor905', 'single user', 'FALSE'
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 = 'epicor905'
kill spid
ALTER DATABASE epicor905 SET MULTI_USER
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 = 'epicor905'
kill spid
ALTER DATABASE epicor905 SET MULTI_USER
No comments:
Post a Comment