Audit SQL account usage

• Gary Andrade

  Ten Centuries

  Points: 1028

  More actions

  April 13, 2004 at 12:40 pm

  #161210

  What is the best way to audit a users (SQL account) activity on a particlular database? 

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  April 13, 2004 at 1:14 pm

  #502631

  If it is a one off trace for a relatively short amount of time, I would use 'sql profiler'. You can set the filters to a database and a user, hence narrowing down the tracing.

  It is best to monitor a few events rather than the lot.

  Otherwise you could setup a server side trace. See sp_trace* in books online.

  Steven

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  April 13, 2004 at 2:25 pm

  #502639

  Profiler is the best way. Cumbersome and only for point use.

• WAGalaxy

  SSC Veteran

  Points: 216

  More actions

  August 24, 2009 at 11:33 pm

  #1043992

  Hi there

  I want to imlement something similar. How did you go in the end?

  Your help/advice is appreciated.

  Thanks

  Brandon