Export (0) Print
Expand All
Expand Minimize

MSpublications (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft