Errant 'Invalid Reason' returned by SQL Prompt for CDC
SignantOzzie
Posts: 6 Bronze 1
in SQL Prompt
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
Doug
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
Doug
