August 6, 2012 at 10:37 pm
I want to create a audit log of all my databases including the logins etc. is thier any script to do this?
August 7, 2012 at 2:10 am
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:
August 7, 2012 at 3:09 am
can i create a database as audit and log all changes to this audit database? if so how can i achieve this?
August 7, 2012 at 3:36 am
What specifics do you want to audit?
August 7, 2012 at 3:39 am
changes to DB records on all the tables in a number of databases, the user making the changes and the date and time
August 7, 2012 at 3:41 am
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