Thread: CDC
View Single Post
  #2 (permalink)  
Old October 20th, 2008, 11:47 AM
aleonard763 aleonard763 is offline
Wrox Author
 
Join Date: Sep 2007
Location: Farmville, VA, USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Vijayig,

   Unfortunately CDC does not work with SQL Server 2005. There are several methods you can use to identify changed rows in a SQL Server 2005 source. They include:

 - Checksums
 - Last Modified Date managed by triggers
 - Change Type tables / columns managed with triggers

Hope this helps,
Andy

Andy Leonard