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;

Read 479 times
(5 in last 30 days)

Rate

3.5 (2)

You rated this post out of 5. Change rating

Share

Share

Rate

3.5 (2)

You rated this post out of 5. Change rating