SQL Server 7.0, NT 4.0
I have distribuition server, whose only role is to be a
distributor, there are no user databases on it. I want to
create login on that server, a login which can only check
the status of logreaders and distribution agents, and to
start or stop them, everyrhing in EM Console - Replication
Monitor. Some users will be able to register Distributor
server in their EM Console using this login.
Does anybody have an idea how to do this?
TIA!
ArminFrom BOL:
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.|||Thank you very much for your answer, Kevin!
But I have a problem - there is no replmonitor role in
distribution database, at least I can not see it. Maybe
this role exists in SQL2K, not in SQL 7.0?
Best regards,
Armin
quote:
>--Original Message--
>From BOL:
>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:
>
>.
>
No comments:
Post a Comment