Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 118

EXEC sp_adddistpublisher @publisher, @security_mode=1,
@distribution_db=@distributiondb,
@publisher_type = 'MSSQLSERVER';

8. Let us change the history retention period and maximum retention period:

-- Change the history retention period to 24 hours and the
-- maximum retention period to 48 hours.
USE distribution
EXEC sp_changedistributiondb @distributionDB, N'history_
retention', 24
EXEC sp_changedistributiondb @distributionDB, N'max_
distretention', 48
GO

9. From SSMS, navigate to the Replication folder and right-click to choose Launch
replication monitor.
10. Replication monitor displays Publisher groups, publisher, and publications.
In order to view such data, we should add a publisher, which is shown in the
following screenshot:

11. The ability to monitor the replication topology is restricted to SYSADMIN fixed server
role member in addition to the db_owner fixed database role.