What are the challenges you face when working across database platforms? Take the survey

Errant 'Invalid Reason' returned by SQL Prompt for CDC

Hey Team,

I have CDC up and running on my server.

When I run the 'Find Invalid Objects' routine - it flags the following 3 objects as invalid for all of the objects enabling and setting up CDC on the server.

Invalid object name 'sysarticles'
Invalid object name 'syspublications'
Invalid object name 'cdc.cdc_jobs'

Twice it got the 'Execution Timout Expired. The timeout period elapsed prior to the completion of the operation or the server is not responding.'

I'd be glad to send you the code to help 

Sign In or Register to comment.