SQL 2008 r2 sys.sp_MSrepl_DistributorReplMonitorAccess Missing?

Posted on 2011-10-19
Last Modified: 2012-05-12
Hello all, i have a simple replication between two SQL 2k8r2 boxes. I am trying to execute sys.sp_replmonitorhelppublisher to get some status info but the script cant locate sys.sp_MSrepl_DistributorReplMonitorAccess as it doesn't seem to exist?

Am i missing something here?

Kind Regards
Question by:AdminPPN
    LVL 29

    Accepted Solution

    I have good news and bad news.
    The good news is that it should be hard to find sys.sp_MSrepl_DistributorReplMonitorAccess.  It is in the mssqlsystemresource database, which is normally hidden and practically impossible to get to.   If you get into it, it's under System Stored Procedures.

    You can't start SQL 2008 without it... so you have to have it.  Any possibility it has been damaged somehow, or you tried to create a copy of the procedure in your local distribution database?  (Although, I would think even that wouldn't work, 'cause I'd assume the procedure in the resource database would override all as a system database...)

    Author Closing Comment

    Thank you, i found an alternate method to achieve goal, sorry for the lateness of my reply but i have been away.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now