MSpublications (Transact-SQL)

Applies to: SQL Server

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's 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 isn't 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 doesn't lock the table during the snapshot)

4 = Concurrent_c (produces a character-mode bulk copy output of all tables but doesn't 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 - copying is disabled
1 - copying 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 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
retention_period_unit tinyint Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
allow_initialize_from_backup bit Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
min_autonosync_lsn varbinary(16) Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.