摘要: SELECT DB_NAME(dbid) as DBName, loginame as LoginName, * FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame ; 阅读全文
posted @ 2013-05-21 17:41 AOT 阅读(117) 评论(0) 推荐(0) 编辑
摘要: 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... 阅读全文
posted @ 2013-05-21 17:31 AOT 阅读(247) 评论(0) 推荐(0) 编辑