Jeff Moden (12/2/2010)

---

I recently had cause to revisit this fine article... well done, Adam. Great for neophytes and alumni alike.

As a side bar, here's the code I ended up using which could actually be turned into an iTVF...

 SELECT trc.LoginName,
     -- trc.LoginSID,
        trc.SPID,
        trc.IsSystem,
        trc.HostName,
        trc.ApplicationName,
        trc.ServerName,
        trc.DatabaseName,
        trc.ObjectName,
        evt.Category_ID,
        CategoryName = cat.name,
        trc.TextData,
        trc.StartTime,
        trc.EventClass,
        trc.EventSubClass,
        EventName = evt.name
   FROM FN_TRACE_GETTABLE( (
                            SELECT CAST([Value] AS NVARCHAR(4000)) --Drive, path, and filename of trace file
                              FROM FN_TRACE_GETINFO(0)             --0 = Current Server
                             WHERE [Property] = 2                  --2 = Trace File Path
                           )
                         ,0) trc --0 = Latest default trace file
  INNER JOIN sys.Trace_Events     evt ON eventclass      = trace_event_id
  INNER JOIN sys.Trace_Categories cat ON evt.category_id = cat.category_id
  WHERE trc.DatabaseName = 'somedatabasenamehere'
    AND trc.ObjectName   = 'somesqlserverobjectnamehere'
;

Heh... and, no... I don't code for things to work on case sensitive servers.

sys.traces T CROSS APPLY
    sys.fn_trace_gettable(CASE WHEN CHARINDEX('_', T.[path]) <> 0
                              THEN SUBSTRING(T.PATH, 1, CHARINDEX('_', T.[path]) - 1) + '.trc'
                              ELSE T.[path]
                         End, T.max_files) TRC

gaffar786 (12/18/2010)

---

Trace ID '3' was stopped because of an error. Cause: Stopping the trace because the current trace file is full and the rollover option is not specified.. Restart the trace after correcting the problem.

i am getting this error on SQL Server, There is default error message enabled on SQL.
How to specifiy the roll over option on default trace.
if i open any default trace files, i am unable to view any roll option on SQL Server profiles studio.

Any idea would be appreciated.

sibir1us (5/9/2011)

---

Here is a nice set of reports on the Default trace: http://sqlconcept.com/default-trace-audit-documentation-and-faq

YSLGuru (5/10/2011)

---

Too bad you have to sign up for yet one more site in order to review/use the item detailed in the post. Maybe its just me but its relaly annoying to be required to sign up for yet one more sites list just to read/review something teh author wants to actualy share with others.

sibir1us (5/10/2011)

---

It is worth it, trust me. :)