[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

How to set audit trial on sql server

Hello,
Need to have a audit trial in sql server. Does the audit trial give information on insert, update, delete, add queries fired by the users?
Cheers
0
RIAS
Asked:
RIAS
  • 2
  • 2
1 Solution
 
zephyr_hex (Megan)DeveloperCommented:
What you're looking for is a parser for the transaction log.  Of course, you'll need to have your database recovery model set to FULL.
0
 
RIASAuthor Commented:
Can you suggest any link
0
 
zephyr_hex (Megan)DeveloperCommented:
That link you posted is for SQL 2016.  The audit feature discussed there is not available in earlier versions.

I don't have a specific tool to recommend, but you can read more about the options by googling.  Here's what I came up with:

https://www.google.com/search?q=sql+transaction+log+parser&ie=utf-8&oe=utf-8
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now