SQL Audit

• MarkoB

  Valued Member

  Points: 62

  More actions

  May 30, 2012 at 10:48 pm

  #256796

  Hi!

  I'm looking for some real life auditing examples. As a dba I need my back covered:-)

  Auditing is not hard to set up, but choosing audit actions and groups is.

  I'm currently using DDL triggers.

  Is it possible to log job actions(enable, disable, alter,...) without trigger on msdb, which is not supported by MS ?

  Thanks.

  Marko.

• Sean Lange

  SSC Guru

  Points: 286609

  More actions

  May 31, 2012 at 8:02 am

  #1495238

  Read today's article. It is part 3 in a series about auditing.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/