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.