Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

SQL 2008 r2 sys.sp_MSrepl_DistributorReplMonitorAccess Missing?

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
1 Solution
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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...)
AdminPPNAuthor Commented:
Thank you, i found an alternate method to achieve goal, sorry for the lateness of my reply but i have been away.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now