摘要: 包含用户名,所在数据库,执行的sql语句,执行开始时间,驱动程序,主机名称SELECT [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid),[User] = nt_username, [Status] = er.status,[Wait] = wait_type,[Individual Query] = SUBSTRING(qt.text, er.statement_start_offset / 2, (CASE WHEN er.statement_end_offset = - 1 THEN LEN(CONVERT(NVARCH.. 阅读全文
posted @ 2012-02-23 11:55 编程笔记 阅读(12799) 评论(1) 推荐(1) 编辑