Using SQL Trace to Audit Database Access

• Haidong Ji

  SSCrazy

  Points: 2453

  More actions

  September 25, 2003 at 6:00 pm

  #475901

  awu,

  I am happy it worked out for you. Glad to be of help.

  Haidong

• Stefan Turalski

  Valued Member

  Points: 71

  More actions

  January 19, 2004 at 12:54 am

  #490613

  Hi,

  What you say about this trace select into your analyze table - i used

  SELECT * INTO dbo.Analyze FROM :: fn_trace_gettable('\\MYHOST\SHAREDFOLDER\trace_filename.trc', default)

  and after giving anyone all access to this folder that works well...

   

• Monica-331108

  SSC Rookie

  Points: 40

  More actions

  May 31, 2006 at 4:52 am

  #640869

   

  Hello,

  I have one  question. The article was very good, I made changes to the script so I could trace what I needed to. One more thing, I am trying to filter not just by application name (column 10) but also by the name of the application so I will get activity for that particular app and I am not having much luck. I am poblably missing something simple but...could you help please?

  Thanks a lot

  Monica

• aamiguens

  SSC Rookie

  Points: 25

  More actions

  May 1, 2008 at 12:05 pm

  #809753

  When I stop running trace, I still cannot open trace file. It seems to keep a lock to it.

• Walker A Impagliatelli

  SSC Rookie

  Points: 25

  More actions

  September 9, 2008 at 2:49 pm

  #869312

  Too cool.

  Thanks.

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  March 26, 2010 at 2:22 pm

  #1140760

  Attached the script, formated for those interested

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  May 24, 2011 at 12:14 pm

  #1329297

  I am getting the error...

  The trace file name is not valid because it contains a rollover file number (NNN in C:\file_NNN) while the trace rollover option is enabled.