Partager via


PublicationAttributes Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The PublicationAttributes property specifies available functions for a Microsoft SQL Server replication publication.

Syntaxe

object
.PublicationAttributes [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer that specifies publication behaviors described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetPublicationAttributes(SQLDMO_PUBATTRIB_TYPE* pRetVal);
HRESULT SetPublicationAttributes(SQLDMO_PUBATTRIB_TYPE NewValue);

Settings

Set value using these SQLDMO_PUBATTRIB_TYPE values.

Constant

Value

Description

SQLDMOPubAttrib_AllowAnonymous

4

Allows anonymous Subscriber-originated subscriptions against the referenced publication.

SQLDMOPubAttrib_AllowPull

2

Allows known Subscriber-originated (pull) subscriptions against the referenced publication.

SQLDMOPubAttrib_AllowPush

1

Allows the Publisher to force subscription to the publication.

SQLDMOPubAttrib_/AllowSubscriptionCopy

100

Allows copying and attaching of the subscription database to other Subscribers.

SQLDMOPubAttrib_/CompressSnapshot

128

Compresses snapshot files.

SQLDMOPubAttrib_Default

1

SQLDMOPubAttrib_AllowPush.

SQLDMOPubAttrib_ImmediateSync

16

Forces immediate synchronization of the referenced publication.

SQLDMOPubAttrib_IndependentAgent

32

Runs the agent as an independent agent.

SQLDMOPubAttrib_InternetEnabled

8

Enables the referenced publication for distribution across the Internet.

SQLDMOPubAttrib_/SnapshotInDefaultFolder

64

Keeps the snapshot copy in the default folder.

SQLDMOPubAttrib_Unknown

256

The referenced publication has an unknown attribute setting.

SQLDMOPubAttrib_Valid

511

A mask for valid attribute settings.

Notes

ThePublicationAttributes property is a bit-packed value that specifies one or more allowed functions. Combine values using the OR logical operator.

For a referenced, Subscriber-initiated subscription, PublicationAttributes is SQLDMOPubAttrib_Min until synchronization occurs and the Subscriber can determine the attributes.

To enable anonymous subscriptions, SQLDMOPubAttrib_AllowPull, SQLDMOPubAttrib_AllowAnonymous and SQLDMOPubAttrib_ImmediateSync must all be specified.

If the SQLDMOPubAttrib_InternetEnabled attribute is specified, the AltSnapshotFolder property must be specified. If the AltSnapshotFolder property is set to NULL or an empty string, SQLDMOPubAttrib_InternetEnabled is automatically turned off.

Notes

If an application sets PublicationAttributes with the MergePublicationor TransPublication object with a setting of SQLDMOPubAttrib_CompressSnapshot, SQLDMOPubAttrib_InternetEnabled, or SQLDMOPubAttrib_SnapshotInDefaultFolder after the initial snapshot has been created, a new snapshot must be generated and then reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and distribution or merge agent run.

Voir aussi

Référence