Export (0) Print
Expand All

How to: View and Modify Publisher Properties (SQL Server Management Studio)

View and modify Publisher properties in the Publisher Properties -<Publisher> dialog box. There are additional Publisher properties associated with the Distributor. For information about viewing and modifying these properties, see How to: View and Modify Distributor Properties (SQL Server Management Studio).

To view and modify Publisher properties

  1. Connect to the Publisher in Microsoft SQL Server Management Studio, and then expand the server node.

  2. Right-click the Replication folder, and then click Publisher Properties.

  3. View and modify properties in the Publisher Properties - < Publisher > dialog box.

    • A user in the sysadmin fixed server role can enable databases for replication on the Publication Databases page. Enabling a database does not publish that database; rather, it allows any user in the db_owner fixed database role for that database to create one or more publications in the database.

    • For Publishers running versions prior to Microsoft SQL Server 2005, a user in the sysadmin fixed server role can register Subscribers on the Subscribers page. Beginning with SQL Server 2005, it is no longer necessary to explicitly register Subscribers for replication.

  4. Modify any properties if necessary, and then click OK.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft