Replication Monitor

Hi !
Now I have SQL Server 2000. Which could be the minimun
privilegies (roles for server) for a user that only need
to review the Replication Monitor ? It doesn't need to
create, eliminate and modify a Publication or Suscription.
In SQL 7.0, I had to use System Administrator Role, but is
was so dangerous (it was a SA), I would know if SQL 2000
have something better about this.
Thanks in advance
Salvador
sdlreyes@.hotmail.comFrom SQL Books online;
users that are not members of the sysadmin fixed server role can monitor
replication if they are defined with the replmonitor role in the
distribution database. A system administrator can add any user to the
replmonitor role, which allows that user to view replication activity with
the Replication Monitor node in SQL Server Enterprise Manager; however, the
user will not be able to administer replication.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||If it's for the user, I wouldn't let them use Replicaiton
Monitor at all. They are mostly concerned with the latency
of their data and whether or not replication is working
end to end.
You can add a dummy single-row table to your publication,
and regularly update that table on the publisher (say once
every minute). Make sure that you timestamp the datetime
the row is updated on the publisher and timestampt when
the row is inserted on the subscriber. Expose the table to
the users on both the publisher and the subscriber and let
them see the time it takes to replicate that row from the
publisher to the subscriber.
This will save you a lot of time explaining to the user
what Replication Monitor reports.
Linchi

quote:

---

>--Original Message--
>Hi !
>Now I have SQL Server 2000. Which could be the minimun
>privilegies (roles for server) for a user that only need
>to review the Replication Monitor ? It doesn't need to
>create, eliminate and modify a Publication or Suscription.
>In SQL 7.0, I had to use System Administrator Role, but

---

is

quote:

---

>was so dangerous (it was a SA), I would know if SQL 2000
>have something better about this.
>Thanks in advance
>Salvador
>sdlreyes@.hotmail.com
>.
>

---

|||Thank you so much !!!
Is Perfect to me!!!

quote:

---

>--Original Message--
>From SQL Books online;
>users that are not members of the sysadmin fixed server

---

role can monitor

quote:

---

>replication if they are defined with the replmonitor role

---

in the

quote:

---

>distribution database. A system administrator can add any

---

user to the

quote:

---

>replmonitor role, which allows that user to view

---

replication activity with

quote:

---

>the Replication Monitor node in SQL Server Enterprise

---

Manager; however, the

quote:

---

>user will not be able to administer replication.
>
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and

---

confers no rights.

quote:

---

>
>.
>

---