MSpublications

Transact-SQL Reference

Transact-SQL Reference

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
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) 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)
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 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
1 = publication is queued