Viewing 6 posts - 1 through 6 (of 6 total)
You can also enable a 2nd CDC capture based on the new columns, then drop the previous CDC capture. The steps are covered in the SQL BOL under CDC...
September 11, 2010 at 9:56 am
This is not a CDC specific message. The "AppDomain 347 ( <any managed code assembly) unloaded." indicates your system was under memory pressure and the managed code assembly was...
September 11, 2010 at 9:53 am
What error message do you get if you try to manually add a row to the CDC tracking tables? Are you providing values for the CDC hidden system columns?
--Chris...
September 11, 2010 at 9:41 am
You may want to keep the CDC table on its own filegroup. This way you can decide if/when to backup the historical CDC table independent from your user tables.
If...
September 11, 2010 at 9:39 am
You need to save th @to_lsn and use that as the new @from_lsn the next time you call the functions. This moves up the bottom water mark to automatically...
September 11, 2010 at 9:35 am
You can also "roll your own" two way Transactional Replication. Just setup up each SQL server as its own Publisher/Distributor and the other SQL Server as the Subscriber. ...
August 17, 2010 at 11:28 am
Viewing 6 posts - 1 through 6 (of 6 total)