Search questions and share your knowledge with the world here on Questionpoint.
Home > Replication Interview Questions > The process could not execute ;sp_replcmds;

:: Categories ::

Interview Question in Replication


 

Interview Question :: The process could not execute ;sp_replcmds;


Hello I've setup transactional replication on SQL SERVER 2000 (SP3). Its been working fine for about 6 months, however i've recently noticed the following error. The process could not execute 'sp_replcmds' on 'servername' . Could anyone shed any light on how to cure this problem.
Answers to "The process could not execute ;sp_replcmds;"
RE: The process could not execute ;sp_replcmds;?

There's any number of reasons for this error. It could be that you have somehow altered the system stored procedure that is named sp_replcmds. It could be that the user you are using does not have proper permission to execute that stored procedure. It's possible the objects you are trying to replicate do not have the proper permissions or structures to be replicated.



Without additional information, it's impossible to tell.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License