Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSpublications

SQL Server 2000

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


Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft