Replication Monitor Monitoring permissions

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  February 26, 2008 at 6:30 pm

  #122468

  Hi ,

  I heard there is no need of sysadmin to monitor replication in sql 2005 and one role is required , can any body point me to that role/permission and also that would be required on publisher/distributor and subscribers?

  Thanks

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 27, 2008 at 9:32 am

  #782625

  The link below should help you.

  http://www.databasejournal.com/features/mssql/article.php/1468971

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  February 27, 2008 at 8:01 pm

  #782957

  Thanks for looking ,but it does not talk about the permissions i am looking , any other pointers?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 28, 2008 at 8:36 am

  #783232

  Please refer to the link

  http://technet.microsoft.com/en-us/library/ms365356.aspx

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  February 28, 2008 at 2:55 pm

  #783472

  The role you are speaking of is the replmonitor database role. This role is found in the distribution database.

  More info:

  http://technet.microsoft.com/en-us/library/ms151221.aspx

  ---

  
  My blog: http://jahaines.blogspot.com

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  February 29, 2008 at 3:04 pm

  #784069

  Thanks Guys , got the answer...