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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Enable Change Data Capture

Author  Topic 

danyeung
Posting Yak Master

102 Posts

Posted - 2009-06-05 : 19:04:33
In SQL 2008, execute a system stored procedure named sys.sp_cdc_enable_table to enable CDC. How do I enable CDC in SQL 2005? When I Google it, only SQL 2008 came up. Thanks.

DanYeung

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-05 : 20:57:37
that's because CDC is a new feature in 2008.
See http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

danyeung
Posting Yak Master

102 Posts

Posted - 2009-06-08 : 10:46:13
There are some CDC tables that works in SQL 2005. I added two tables to the CDC replication but they don't work. I am not sure what step I missed. Any idea? Thanks.

DanYeung
Go to Top of Page
   

- Advertisement -