Share via


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)

5 = Database Snapshot, which means that native-mode BCP is used tp copy data from a database snapshot.

6 = Database Snapshot Character, which means that character-mode BCP is used tp copy data from a database snapshot.

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

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

New content:
  • Added information about new values for the sync_method column.