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:
>
>.
>
