0

Guys, please suggest me, how can I set up an audit on SQL server 2008 if I need to track who, when, what and from where changed something on a database table?

3
Contributors
5
Replies
22
Views
3 Years
Discussion Span
Last Post by BlindArcher
0

Hi pritaeas,
Thanks for sharing useful article link.
But could you please suggest me any automated option instead of scripting language?
Actually, scripting is about bit complicated for me and I am not much familier with this.

0

I don't know any (none come to mind), but am sure there are tools to help you do this. Perhaps RedGate has one.

0

Hi Pritaeas,
Thanks for advice. But Redgate seems bit costly.
However, I have also explored and discussed with several professionals for the same. And If I compare them, Lepide sql auditor comes under my budget which claims about good services of my concern. But let me check the demo either it's an appropriate or not.

0
CREATE SERVER AUDIT PCI_Audit
TO FILE (FILEPATH = ’F:\AuditLogs\’, MAXSIZE = 1GB, MAX_ROLLOVER_FILES = 80)
WITH (QUEUE_DELAY = 0, ON_FAILURE = SHUTDOWN)

Edited by pritaeas: Added markdown.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.