MSpublications (Transact-SQL)
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 Microsoft SQL Server database: 0 = SQL Server. 1 = Data source other than 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) |
The description of the publication. |
vendor_name |
nvarchar(100) |
The name of the vendor if Publisher is not a SQL Server 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 SQL Server Management Studio is suppressed: 0 = Display a heterogeneous publication in the Replication folder in SQL Server Management Studio. 1 = Suppress the display a heterogeneous publication in the Replication folder in SQL Server Management Studio. |
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. |
See Also
Reference
Replication Views (Transact-SQL)