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 |
|