The PublicationAttributes property specifies available functions for a Microsoft® SQL Server™ replication publication.
| DistributionPublication Object | TransPublication Object |
| MergePublication Object | TransPullSubscription Object |
object.PublicationAttributes [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying publication behaviors as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOPubAttrib_ AllowAnonymous |
4 | Allow anonymous Subscriber-originated subscriptions against the referenced publication |
| SQLDMOPubAttrib_AllowPull | 2 | Allow known Subscriber-originated (pull) subscriptions against the referenced publication |
| SQLDMOPubAttrib_AllowPush | 1 | Allow Publisher to force subscription to the publication |
| SQLDMOPubAttrib_Default | 1 | SQLDMOPubAttrib_ AllowPush |
| SQLDMOPubAttrib_ImmediateSync | 16 | Force immediate synchronization for the referenced publication |
| SQLDMOPubAttrib_ IndependentAgent |
32 | Referenced publication uses a heterogeneous Distribution Agent (TransPullSubscription object only) |
| SQLDMOPubAttrib_InternetEnabled | 8 | Enable the referenced publication for distribution across the Internet |
| SQLDMOPubAttrib_Min | 0 | Referenced publication is disabled or the attributes are unknown |
| SQLDMOPubAttrib_Unknown | 256 | Referenced publication has a bad or unknown attribute setting |
| SQLDMOPubAttrib_Valid | 63 | Mask for valid attribute settings |
The PublicationAttributes property is a bit-packed value specifying one or more allowed functions. Combine values using an Or.
For a referenced, Subscriber-initiated subscription, PublicationAttributes is SQLDMOPubAttrib_Min until synchronization occurs and the Subscriber can determine the attributes.
Long, enumerated
Read/write
HRESULT GetPublicationAttributes(
SQLDMO_PUBATTRIB_TYPE* pRetVal);
HRESULT SetPublicationAttributes(
SQLDMO_PUBATTRIB_TYPE NewValue);