| title | MSpublications (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 7a0b3457-7265-4f24-a255-7f055d908f20 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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 | The ID of the Publisher. |
| publisher_db | sysname | The name of the Publisher database. |
| publication | sysname | The name of the publication. |
| publication_id | int | The ID of the publication. |
| publication_type | int | The type of publication: 0 = Transactional. 1 = Snapshot. 2 = Merge. |
| thirdparty_flag | bit | Indicates whether a publication is a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] database: 0 = [!INCLUDEssNoVersion]. 1 = Data source other than [!INCLUDEssNoVersion]. |
| 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) | The description of the publication. |
| vendor_name | nvarchar(100) | The name of the vendor if Publisher is not a [!INCLUDEssNoVersion] database. |
| retention | int | The retention period of the publication, in hours. |
| sync_method | int | The synchronization method: 0 = Native (produces native-mode bulk copy output of all tables). 1 = Character (produces a character-mode bulk copy output of all tables). 3 = Concurrent (produces native-mode bulk copy output of all tables but does not lock the table during the snapshot). 4 = Concurrent_c (produces a character-mode bulk copy output of all tables but does not lock the table during the snapshot) The values 3 and 4 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 [!INCLUDEssManStudioFull] is suppressed: 0 = Display a heterogeneous publication in the Replication folder in [!INCLUDEssManStudioFull]. 1 = Suppress the display a heterogeneous publication in the Replication folder in [!INCLUDEssManStudioFull]. |
| allow_queued_tran | bit | Specifies whether publication allows queued updating: 0 = Publication is non-queued. 1 = Publication is queued. |
| options | int | No information is available for this release. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)