SQL 2008 Audit

  • I want to create a audit log of all my databases including the logins etc. is thier any script to do this?

  • There's no catch all script as "Audit" means different things to different DBA's.

    However, take a look at http://www.brentozar.com/blitz/ which was recommended to me and is a great starting point.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • can i create a database as audit and log all changes to this audit database? if so how can i achieve this?

  • What specifics do you want to audit?

  • changes to DB records on all the tables in a number of databases, the user making the changes and the date and time

  • Looks like you need change data capture then, which is a SQL Enterprise only feature, either that or create custom triggers on the tables in question to log to an audit database.

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

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