MSpublications
The MSpublications table contains one row for each publication that is replicated by a Publisher. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| publisher_id | smallint | ID of the Publisher. |
| publisher_db | sysname | Name of the Publisher database. |
| publication | sysname | Name of the publication. |
| publication_id | int | ID of the publication. |
| publication_type | int | Type of publication:
0 = Transactional |
| thirdparty_flag | bit | Indicates whether a publication is a Microsoft® SQL Server™ database:
0 = SQL Server |
| independent_agent | bit | Indicates whether there is a stand-alone Distribution Agent for this publication. |
| immediate_sync | bit | Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs. |
| allow_push | bit | Indicates whether push subscriptions can be created for the given publication. |
| allow_pull | bit | Indicates whether pull subscriptions can be created for the given publication. |
| allow_anonymous | bit | Indicates whether anonymous subscriptions can be created for the given publication. |
| description | nvarchar(255) | Description of the publication. |
| vendor_name | nvarchar(100) | Name of the vendor if Publisher is not a SQL Server database. |
| retention | int | Retention period of the publication, in hours. |
| sync_method | int | Synchronization method:
0 = native (produces native-mode bulk copy output of all tables) The values concurrent and concurrent_c are available for transactional replication and merge replication, but not for snapshot replication. |
| allow_subscription_copy | bit | Enables or disables the ability to copy the subscription databases that subscribe to this publication. 0 means that copying is disabled, and 1 means it is enabled. |
| thirdparty_options | int | Specifies whether the display of a publication in the Replication folder in SQL Server Enterprise Manager is suppressed:
0 = display a heterogeneous publication in the Replication folder in SQL Server Enterprise Manager 1 = suppress the display a heterogeneous publication in the Replication folder in SQL Server Enterprise Manager |
| allow_queued_tran | bit | Specifies whether publication allows queued updating:
0 = publication is non-queued |