摘要: --统计表的增删改次数,反映表的使用程度 SELECT DB_NAME([database_id]) AS [Database] ,iops.[object_id] AS [ObjectID] ,QUOTENAME(OBJECT_SCHEMA_NAME(iops.[object_id], [data 阅读全文
posted @ 2016-06-23 14:14 两年十一时 阅读(145) 评论(0) 推荐(0) 编辑
摘要: 报错The database is in single-user mode, and a user is currently connected to it. 通过 select * from sys.sysprocesses 找不到 通过 select * from sys.dm_exec_req 阅读全文
posted @ 2016-06-23 13:49 两年十一时 阅读(250) 评论(0) 推荐(0) 编辑