May 20, 2014 at 3:33 am
CDC is disabling when we do bulkinserts\updates\change schema .
how to findout why CDC disabled and how to prevent it ?
May 20, 2014 at 4:11 am
What information are you using to state that CDC is disabling?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 20, 2014 at 6:14 am
Refer following link which might be useful:
http://msdn.microsoft.com/en-us/library/cc627369.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 6:16 am
foundout the CDC state by using below query.
select is_cdc_enabled ,* from sys.databases where name = 'xxxxx'
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply