当前位置: 代码迷 >> Sql Server >> 跟踪的记录放在哪?解决办法
  详细解决方案

跟踪的记录放在哪?解决办法

热度:90   发布时间:2016-04-27 18:56:46.0
跟踪的记录放在哪?
跟踪的记录放在哪?找了一下master,msdb,model都没有找那个表
再去看了看SQL日志,也没有对应的时间日期的记录?
那类似以下的记录是哪里来的,直接来自内存??????
Audit   Login --   network   protocol:   LPC
set   quoted_identifier   on
set   implicit_transactions   off
set   cursor_close_on_commit   off
set   ansi_warnings   on
set   ansi_padding   on
set   ansi_nulls   on
set   concat_null_yields_null   on
set   language   简体中文
set   dateformat   ymd
set   datefirst   7
MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 3748 56 2007-05-17   10:51:45.570
SQL:BatchCompleted select   504,c.name,c.description,c.definition   from   master.dbo.syscharsets   c   where   c.id   =   convert(tinyint,   databasepropertyex   (   db_name()   ,   'sqlcharset ')) MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 0 43 0 0 3748 56 2007-05-17   10:51:45.580
SQL:BatchCompleted SET   QUOTED_IDENTIFIER,   ARITHABORT,   CONCAT_NULL_YIELDS_NULL,   ANSI_NULLS,   ANSI_PADDING,   ANSI_WARNINGS   ON
  SET   NUMERIC_ROUNDABORT   OFF
MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 0 0 0 0 3748 56 2007-05-17   10:51:45.580
SQL:BatchCompleted SET   NO_BROWSETABLE   ON MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 0 0 0 0 3748 56 2007-05-17   10:51:45.610
SQL:BatchCompleted SELECT   *   FROM   SYSREMOTE_STATISTICS MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 0 20 0 0 3748 56 2007-05-17   10:51:45.610
Audit   Logout MS   SQLEM   -   Data   Tools Administrator HBTX-PRINTER\Administrator 220 89 0 6250 3748 56 2007-05-17   10:51:45.570


------解决方案--------------------
帮顶
  相关解决方案