MSpublications (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

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 nameData typeDescription
publisher_idsmallintThe ID of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publicationsysnameThe name of the publication.
publication_idintThe ID of the publication.
publication_typeintThe type of publication:

 0 = Transactional.

 1 = Snapshot.

 2 = Merge.
thirdparty_flagbitIndicates whether a publication is a Microsoft SQL Server database:

 0 = SQL Server.

 1 = Data source other than SQL Server.
independent_agentbitIndicates whether there is a stand-alone Distribution Agent for this publication.
immediate_syncbitIndicates whether synchronization files are created or re-created each time the Snapshot Agent runs.
allow_pushbitIndicates whether push subscriptions can be created for the given publication.
allow_pullbitIndicates whether pull subscriptions can be created for the given publication.
allow_anonymousbitIndicates whether anonymous subscriptions can be created for the given publication.
descriptionnvarchar(255)The description of the publication.
vendor_namenvarchar(100)The name of the vendor if Publisher is not a SQL Server database.
retentionintThe retention period of the publication, in hours.
sync_methodintThe 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_copybitEnables 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_optionsintSpecifies 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_tranbitSpecifies whether publication allows queued updating:

 0 = Publication is non-queued.

 1 = Publication is queued.
optionsintNo information is available for this release.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft