Technical Article

View Errors in the Default Trace

,

Just run it

DECLARE  @TrcFile NVARCHAR(256);

SELECT @TrcFile = Convert(NVARCHAR(256),VALUE)
FROM   Fn_trace_getinfo(DEFAULT)
WHERE  property = 2;

SELECT   textdata,
         databaseid,
         transactionid,
         hostname,
         clientprocessid,
         applicationname,
         loginname,
         spid,
         starttime,
         severity,
         servername,
         eventclass,
         ERROR,
         databasename,
         loginsid,
         requestid,
         eventsequence,
         sessionloginname
FROM     Fn_trace_gettable(@TrcFile,DEFAULT)
WHERE    ERROR IS NOT NULL
ORDER BY starttime;

Rate

3.5 (2)

Share

Share

Rate

3.5 (2)