Solved

sql Audit table

Posted on 2016-09-25
3
67 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 28

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

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…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

831 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