Nota
L'accés a aquesta pàgina requereix autorització. Podeu provar d'iniciar la sessió o de canviar els directoris.
L'accés a aquesta pàgina requereix autorització. Podeu provar de canviar els directoris.
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The PublicationAttributes property specifies available functions for a Microsoft SQL Server replication publication.
Sintaxis
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. |
Notas
The PublicationAttributes 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.
[!NOTA] If an application sets PublicationAttributes with the MergePublication or 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.