December 7, 2005 at 7:07 am
I have just finished running all of the wizards successfully for transactional
replication . In order to test, we have selected one table and inserted 1 row in the publisher and wanted to see the replication in the subscriber
what we have found that after replication has finshed a set of replication stored procedures have been constructed something like sp_Ms<ins or del or upd>_<table_name>_1 ... Please note the last suffix underscore 1... Is this a bug in sql server 2000 replication OR can we just rename these procedures?
and replication says "..can't find procedure sp_Ms<ins or del or upd>_<table_name>.."
jasq : should I just rename or is there a patch
December 8, 2005 at 3:16 am
This seems like the replication existed earlier also and was not properly removed.
Can you see the same stored procs without _1.
Anurag.
December 8, 2005 at 9:02 am
we made the attempt to generate the replicate stored procedures sp_..._1 to sp_...<table_name>
performed an update to a record
still said sp not found
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply