September 3, 2011 at 2:34 am
hi all.
I enable databse for cdc and then want to enable tables for cdc but get error:insure that the correct database context is set .why?
September 3, 2011 at 7:04 am
baglobalassociates (9/3/2011)
Source table '%s.%s' does not exist in the current database. Ensure that the correct database context is set. Specify a valid schema and table name for the database.
I do not follow you but I love the spam in the signature block. Nice.:-D
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 3, 2011 at 7:05 am
elham_azizi_62 (9/3/2011)
hi all.I enable databse for cdc and then want to enable tables for cdc but get error:insure that the correct database context is set .why?
Could you please provide the exact error message and check the error logs?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 4, 2011 at 4:56 am
loop
Thanks
September 4, 2011 at 6:20 am
Hi (Ba Salam)
I think you did one of the following by mistake:
1: You drop the cdc.change_tables CDC system table.
2: You run the sp_cdc_disable_db stored procedure to disable CDC.
Now You have to update with the following updates of SQL Server 2008
Cumulative update package 4 for SQL Server 2008
http://support.microsoft.com/kb/963036
then use the sys.sp_cdc_enable_db stored procedure to enable CDC again
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply