Member Avatar for carlton_1

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
  • 170 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by BlindArcher
Member Avatar for carlton_1

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.

Member Avatar for pritaeas

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

Member Avatar for carlton_1

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.

Member Avatar for BlindArcher 
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 because: Added markdown.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.