Solved

How to set audit trial on sql server

Posted on 2016-08-17
4
56 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 43

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
 

Author Comment

by:RIAS
ID: 41760211
0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
query output (script) from a stored procedure 4 52
sql server major issue  need help 2 82
Help with SQL pivot 11 49
I am new to using JSON in SQL Server 2 57
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 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