Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Need to Audit the Insert , Delete , Update in DBs

Author  Topic 

turbo
Starting Member

19 Posts

Posted - 2012-12-24 : 01:29:38
Hi ,
Can Anyone help me out how i can capture and audit the insert , Update , deletion of table data in all DBs.

Thanks in advance.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-24 : 02:47:40
You can do by using the following
1) Change Data Capture
2) Triggers


--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-24 : 15:40:19
http://richbrownesq-sqlserver.blogspot.in/2011/12/t-sql-audit-data-changes.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -