How to view or modify publication properties (Enterprise Manager)

Note If subscriptions have been created to the publication, some properties are disabled and cannot be changed.

To view or modify publication properties

1. Expand a server group; then expand the Publisher.
2. On the Tools menu, point to Replication, and then click Create and Manage Publications.
3. Expand the database containing the publication to modify.
4. Click the publication to modify; then click Properties & Subscriptions.
5. In the Publication Properties dialog box, click the General tab to view the publication name, database name, and type of publication. You can also view or modify the publication description, the initial snapshot file format, or the synchronization time limit.
6. Click the Articles tab to add, remove, or change the properties of an article.
7. Click Filter Columns to filter the columns in published tables. This option is available for snapshot or transactional publications only.
8. Click Filter Rows to filter the rows in published tables.
9. Click the Subscriptions tab to push, delete, reinitialize, or view the properties of subscriptions.
10. Click Subscription Options to allow pull subscriptions, allow anonymous Subscribers to pull subscriptions, allow immediate-updating Subscribers, and allow subscriptions to download snapshots using FTP.
11. Click Publication Access List to specify the logins that have access to the publication.
12. Click the Status tab to view the status of the Snapshot Agent, run the Agent, view Agent properties, or start the services required by the publication.
13. Click the Scripts tab to create a script that would create or delete this publication.

See Also

Viewing or Modifying Publication Properties