Post reply

Audit listing of Select Statements

  • January 29, 2008 at 10:26 am

    #186073

    I'm looking for a method for monitoring/auditing browsing.

    I'm aware of Lumigent, but after reviewing the hooks that it needs into the database/network I'd like to find a simpler alternative.

    Is there a 'simple' way to output a listing of Select statements in SQL Server -- not the results returned - just the Select statement?

    James

  • January 30, 2008 at 9:08 am

    #773364

    I don't know if you will consider this "easy" but SQL Server Profiler should do the trick. Look for the event class 'TSQL'

    [font="Verdana"]EKD[/font]

  • January 30, 2008 at 9:46 am

    #773394

    You could enable C2 auditing. C2 auditing can be detrimental to performance and is not always 100% accurate, but it provides a very robust method for tracking access to SMOs. The output file can be launched via profiler and is quite legible.

    more info:

    http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/

    http://msdn2.microsoft.com/en-us/library/ms187634.aspx


    My blog: http://jahaines.blogspot.com

  • January 31, 2008 at 1:16 am

    #773653

    Take care - C2 Auditing seemed to cause my server to crash.

    Disabled it and no crashes since (6 months).

  • January 31, 2008 at 3:58 am

    #773671

    Take care - C2 Auditing seemed to cause my server to crash.

    C2 Auditing is handled through trace events. I prefer to use customized trace (store them to a file.)

    You can automate it.

    Profiler has UI, trace doesn't have one, other than that fucntionality wise you will capture the sme information.

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

Viewing 5 posts - 1 through 4 (of 4 total)

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