摘要:
SELECT DB_NAME(dbid) as DBName, loginame as LoginName, * FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame ; 阅读全文
摘要:
ALTER DATABASE OKQ8 SET SINGLE_USER WITH ROLLBACK IMMEDIATE--AFTER 60 SECONDSALTER DATABASE OKQ8 SET ENABLE_BROKER --DISABLE_BROKER WITH NO_WAIT--do you stuff hereALTER DATABASE OKQ8 SET MULTI_USER... 阅读全文