Recent update: 2008-3-21
According to BOL the default CDC retention time is 3 days and it was mentioned that it configurable. Can some of point me on how to change the default value. Thanks in advance.
Hi, Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages? I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live ...
I executed below scenarios and the behaviour seems to be inconsistent. I noticed cdc.change_tables tracks table details with index_name but BOL doesn't explain what is/isn't possible interms of modifying PK. Is #1 by design, if so it needs to be clarified. Enable CDC on a table with PK. ...
Hi, Is available any tutorial or example which shows how to use Change Data Capture in Integration Services Packages? I have found Using Change Data Capture in Integration Services Packages topic in BOL but there is an error and I can not open it. There is also Change Data Capture live ...
976 byte By
Ronzo3 at 2008-1-8
SP_ADDSUBSCRIPTION @publication = N'LTDB', @article = N'all', @subscriber = N'co-sub', @destination_db = N'RonsLT', @sync_type = N'replication support only' produces following error on SQL 2008 June CTP x64 (haven't installed July yet.) HResult 0x1FD1, Level 16, State ...
An interesting option would be to use INSTEAD OF triggers on the CDC tables. It is more work but opens possibilities like: logging on a different server (I would not recommend it, but at least it is possible) pivot the table to audit in an old-value/new-value format (and only changes, so less ...
I have tried code for CDC in Katmai CTP 4 : Code Snippet declare @from_lsn binary(10) set @from_lsn = sys.fn_cdc_get_min_lsn('Person.Contact') declare @to_lsn binary(10) set @to_lsn = sys.fn_cdc_get_max_lsn() declare @row_filter_option nvarchar(10) set @row_filter_option = 'all' -- ...
976 byte By
Ronzo3 at 2008-1-8
SP_ADDSUBSCRIPTION @publication = N'LTDB', @article = N'all', @subscriber = N'co-sub', @destination_db = N'RonsLT', @sync_type = N'replication support only' produces following error on SQL 2008 June CTP x64 (haven't installed July yet.) HResult 0x1FD1, Level 16, State ...
976 byte By
Ronzo3 at 2008-1-7
SP_ADDSUBSCRIPTION @publication = N'LTDB', @article = N'all', @subscriber = N'co-sub', @destination_db = N'RonsLT', @sync_type = N'replication support only' produces following error on SQL 2008 June CTP x64 (haven't installed July yet.) HResult 0x1FD1, Level 16, State ...
I have tried code for CDC in Katmai CTP 4 : Code Snippet declare @from_lsn binary(10) set @from_lsn = sys.fn_cdc_get_min_lsn('Person.Contact') declare @to_lsn binary(10) set @to_lsn = sys.fn_cdc_get_max_lsn() declare @row_filter_option nvarchar(10) set @row_filter_option = 'all' -- ...
I have a default full install of the JULY CTP on X86 Windows Server 2003 (fully up to date on the patches). I used the Merge Replication Sample to create the Publisher/Publication. SInce the code sample to create the subscriber doesn't work (apparently some major changes in the assemblies) I ...
I executed below scenarios and the behaviour seems to be inconsistent. I noticed cdc.change_tables tracks table details with index_name but BOL doesn't explain what is/isn't possible interms of modifying PK. Is #1 by design, if so it needs to be clarified. Enable CDC on a table with PK. ...
With SQL Server 2005 adding a merge filter that used a column with a date did not work very well. I have a table that has an expiration date. Ideally, I would want to set a filter that says send to the subscriber if getdate() < expirationdate. The problem in 2005 is that since the data in ...
I executed below scenarios and the behaviour seems to be inconsistent. I noticed cdc.change_tables tracks table details with index_name but BOL doesn't explain what is/isn't possible interms of modifying PK. Is #1 by design, if so it needs to be clarified. Enable CDC on a table with PK. ...
An interesting option would be to use INSTEAD OF triggers on the CDC tables. It is more work but opens possibilities like: logging on a different server (I would not recommend it, but at least it is possible) pivot the table to audit in an old-value/new-value format (and only changes, so less ...
Hello I've got error during setting up subscriptions on CTP3 SQL Server could not create a subscription for Subscriber 'FRANSIDI06\KATMAI'. (Configure Peer-To-Peer Topology Wizard)ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. ...