SQL Server Forums - Need to Audit the Insert , Delete , Update in DBs

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Need to Audit the Insert , Delete , Update in DBs

New Topic

Author

Topic

turbo
Starting Member

18 Posts

Posted - 12/24/2012 : 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
Flowing Fount of Yak Knowledge

India
1451 Posts

Posted - 12/24/2012 : 02:47:40

You can do by using the following
1) Change Data Capture
2) Triggers

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts

Posted - 12/24/2012 : 15:40:19

http://richbrownesq-sqlserver.blogspot.in/2011/12/t-sql-audit-data-changes.html

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

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.11 seconds.