SQL Server 2008 functionality for Audit Log

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

SQL Server Administration (2008)

SQL Server 2008 functionality for Audit Log

Author

Topic

totaltech
Starting Member

1 Post

Posted - 2009-11-18 : 00:53:56

Hello

I have to implement a functionality for audit( insert/update/delete ) log of the each table.

There are two option
1) Through SQL Server 2008 Feature : I heard that in the SQL Server 2008 we have CDC(Change Data Capture) features which can be enable on each table and track each data changes. It insert new row into a special system table which we need audit log.

2) Create a unnormalized table for each table and handle the audit (insert/update/delete) log using the trigger.

Can anybody help to me to choose which options is best and easy to manage in the future?

Thanks,
Craig
www.totaltechresource.com

support.sql
Starting Member

15 Posts

Posted - 2009-11-29 : 19:25:11

What is the details that you need to audit record (User,Operation, Old Value,etc )?

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources