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.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-03-03 : 17:18:16
|
| Guys,I was looking at the auditing capabilities of SQL 2008, it seems like it only audits the DML statements on a given table. It does not actually capture any before or after data images for DML actions. Is there a feature in SQL 2008 that can be used to capture data images before or after the dml action. Any suggestions/inputs would help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-04 : 03:38:41
|
| the most obvious is trigger usage. You can also wrap all your change statements into stored procedures and put auditing logic inside them. You can also use lumigent log explorer to see the transactions' before/after from database log to not add overhead to your production db.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-04 : 14:01:15
|
| There is a CDC (Change Data Capture) feature available in Enterprise Editions only that might be of interest to you.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Auditing in SQL 2008