The process could not execute 'sp_replcmds'

Question

The process could not execute 'sp_replcmds'

Tarun Jaggi

Hall of Fame

Points: 3365
More actions
November 21, 2010 at 10:56 pm

#241567

I am trying to implement Transactional Relication within a SQL Server 2008 instance but when I go through the replication monitor it is showing the below message:
The process could not execute 'sp_replcmds' on INSTANCENAME
Seeking for the advice from your side.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Do you have any filters set for your replication?

It could be problem with the log reader. I have heard people saying that a reboot will solve this. Usually it is not easy to fix other than dropping and recreating the subscription.

You could also try to run sp_repldone and then try to find the offending command and remove it manually.

-Roy

dbamohsin SSCommitted Points: 1948 More actions · Answer 2

Can you give more details about your setup?

My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access[/url]

gk-411903 Hall of Fame Points: 3801 More actions · Answer 3

Check the ownership of the database on the server. May be you restored the db and are trying to set up the replication.