CDC does not require Unique Indexhttp://blogs.msdn.com/b/repltalk/archive/2010/05/25/cdc-does-not-require-unique-index.aspxUnique Index not required for Change Data Capture Chris Skorlinski Microsoft SQL Server Escalation Services Change Data Capture feature of SQL 2008 is based on Transactional Replication.  CDC and Transactional Replication used the same internal storeden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)