question

Mark-6196 avatar image
0 Votes"
Mark-6196 asked AmeliaGu-msft commented

Removed publication is causing a 'Could not find stored procedure' error

I set up a new publication last night and as part of my tidy-up process, I removed the old publication.

Unfortunately, when I try to do a certain task in our software I am getting the below error

EXCEPTION: Could not find stored procedure 'dbo.MSmerge_expand_sp_D21238F0462D48ECADBC8C21539E0839'.
The statement has been terminated.

I have backups however the stored procedures are not there and I believe this is down to the recovery model - currently set to Simple.

What is the best way of resolving this error?

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Mark-6196,
Was your issue resolved?
Please feel free to let us know if you have any other question.
If the answer is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi Mark-6196,
Could you locate the store procedure on other subscribers? If so you can try to copy it.
When you get errors like this your replication metadata is inconsistent, you can try to regenerate and redistribute the snapshot. Please refer to this similar thread which might help.
In addition, if this database has no other publications, you can execute sp_replicationdboption to disable publication of the current database using merge replication.
Best Regards,
Amelia


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.