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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-06-01 : 01:43:24
|
| hello everybody, when we enable CDC feauture in sql 2008 it tracks all the DML operations done on a atable and stores them into a audit table.where can i find the audit table???thanks in advance |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-06-02 : 04:58:11
|
| cdc table will be created in system tables with schema CDC and table name will be same to your orignal table name but with edition "_CT", for further detail information http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-(cdc)-in-sql-server-2008/ |
 |
|
|
|
|
|
CDC