Solved

sql Audit table

Posted on 2016-09-25
3
59 Views
Last Modified: 2016-10-27
Hi , I need to create audit Log, any user add any records to table  what is old value and new value
For example
some one add employee Table

Audit Table

Empid employeeSalary Datechanged Createdby
1             20000               20/08/2015      ryan         <------ Old Records
1             30000               25/09/2015      Stephen  <----- New Records


After add new records

I need to do at least 50 tables.

Thanks
0
Comment
Question by:ukerandi
3 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 41815000
Take a look at CDC.
0
 
LVL 24

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41815214
There are multiple options for auditing in SQL Server. They are

Server level

1. C2 Auditing.
2. Common Criteria compliance

 try and consider server level auditing. right click on the server and you will get these options. these options are really good since you have do it on larger number of table.

Also you just need to set this option and SQL will handle everything internally.

Enjoy !
Auditing.jpg
0
 
LVL 10

Author Closing Comment

by:ukerandi
ID: 41863159
thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

895 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now