question

jmh9403 avatar image
jmh9403 asked

Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'

I am using sql 2012 Interprize and replication The data base i am trying replicate from is being used all the time So i built a test bed server cmc-a (publisher) and cmc-c I backed up database from cmc-a and put it on server cmc-c then i followed the instructions for p2p replication and at end I selected "I restored a backup of the original publication database, and the publication database was changed after the backup was taken" When the process finished I made a change to cmc-a (publisher) I get the following error from replication monitor "Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'. (Source: MSSQLServer, Error number: 2812)" So ran the following sql script on server cmc-a to find the procedure "SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME like '%sp_MSins_dbotextmsg_filed%'" I get the following. "sp_MSins_dbotextmsg_unfiled_content014368500850223599121" Does this procedure need to be on both databases if not what could be my problem
replicationp2p
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.