What is the minimum SQL Server permission that I should give to created new user in SQL Server 2005, to run and see items on Replication monitor

Mohd A. Shalabi

__________________
Mohd A. Shalabi

From BOL:

"The ability to monitor a replication topology is restricted to the sysadmin fixed server role, the db_owner fixed database role, and the replmonitor fixed database role on the distribution database. You can add users to the replmonitor fixed database role programmatically using system stored procedures."

For more info, look up "Replication Monitor" in BOL. There is a lot of information in there.


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html