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?
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.
I don't know any (none come to mind), but am sure there are tools to help you do this. Perhaps RedGate has one.
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.
CREATE SERVER AUDIT PCI_Audit TO FILE (FILEPATH = ’F:\AuditLogs\’, MAXSIZE = 1GB, MAX_ROLLOVER_FILES = 80) WITH (QUEUE_DELAY = 0, ON_FAILURE = SHUTDOWN)