Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to set audit trial on sql server

Posted on 2016-08-17
4
Medium Priority
?
77 Views
Last Modified: 2016-08-22
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
Comment
Question by:RIAS
  • 2
  • 2
4 Comments
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41760173
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
 

Author Comment

by:RIAS
ID: 41760207
Can you suggest any link
0
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 2000 total points
ID: 41760333
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question