Post reply

Using SQL Trace to Audit Database Access

  • September 25, 2003 at 6:00 pm

    #475901

    awu,

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

    Haidong

  • 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...

     

  • 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

  • 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.

  • September 9, 2008 at 2:49 pm

    #869312

    Too cool. 😎

    Thanks.

  • 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

  • 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.

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply