Export (0) Print
Expand All
Expand Minimize

publication Properties, Subscription Options Tab (SQL Server 7.0 Transactional Publication)

SQL Server 2000

The following options are available on the Subscription Options tab of the publication Properties dialog box.


Use a Distribution Agent that is independent of other publications from this database

Select whether the publication uses a separate Distribution agent. Having all the publications at the Publisher use the same Distribution Agent reduces the resource demands and increases performance at the Distributor. However, if your application requires immediate synchronization or allows anonymous subscriptions, you must have a separate Distribution Agent for this publication.

Snapshot files are always available to immediately initialize new subscriptions

Select whether to continuously maintain a current snapshot of the publication so that new subscriptions can be initialized as soon as the subscription is created.

Allow anonymous Subscribers to pull subscriptions

Select whether anonymous Subscribers are allowed to create pull subscriptions to the publication.

Allow enabled Subscribers to pull subscriptions

Select whether those Subscribers who have been specifically enabled are allowed to create pull subscriptions to the publication. Subscribers are enabled on the Subscribers tab of the Publisher and Distributor Properties dialog box.

Allow snapshots to be downloaded using FTP (File Transfer Protocol)

Select whether enabled Subscribers or anonymous Subscribers can use file transfer protocol (FTP) to download the snapshot file over the Internet.

Allow immediate updating subscriptions

View whether a Subscriber can modify subscription data and have those changes replicated to the Publisher.

© 2014 Microsoft