MSpublications (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)