Database Reference
In-Depth Information
12. Let us add a user to the replmonitor fixed database role on the distributor, from
Query Editor by executing the following TSQL statements:
CREATEUSER [user_name] FORLOGIN [user_name] WITH
DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolememberN'db_datareader',N'user_name'
GO
EXEC sp_addrolememberN'db_denydatawriter',N'user_name'
GO
USE [distribution]
GO
EXEC sp_addrolememberN'replmonitor',N'user_name'
GO
USE [distribution]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [user_name]
GO
EXEC sp_addrolememberN'db_owner',N'user_name'
GO
13. From the previous TSQL statements, the information is now added, which is visible on
the left pane of replication monitor (see the next screenshot):
14. The Replication Monitor displays information about the publisher on three tables:
Publications tab, Subscription watch list, and agents tab.
15. The publications tab provides summary information for all publications at the
publisher. The subscription watch list is intended to display subscriptions from all
publications available at the selected publisher.
 
Search WWH ::




Custom Search