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 |
|
PingTheServer
Starting Member
28 Posts |
 Posted - 2011-04-20 : 17:07:54
|
| I was curious, we recently got SQL 2k8 and are preparing a data migration and a new application to go with it. A co-worker seemed to think change tracking could act as like an audit log to see what rows were altered, their previous/current values, when, and by who. The more i read up on it, it doesnt seem like that's what it was created for.Does anyone know if there is a feature built in to SQL 2k8 that will perform the function of logging info about rows that were updated?Thx |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-25 : 07:07:05
|
| "CDC is one of the new data tracking and capturing features of SQL Server 2008. It only tracks changes in user-created tables. Because captured data is then stored in relational tables, it can be easily accessed and retrieved subsequently, using regular T-SQL."Introduction to Change Data Capture (CDC) in SQL Server 2008 (By: Pinal Dave)http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
Question re: Change Tracking