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 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 = Transactional1 = Snapshot2 = Merge |
thirdparty_flag |
bit | Indicates whether a publication is a Microsoft SQL Server database:0 = SQL Server1 = Data source other than SQL Server |
independent_agent |
bit | Indicates whether there's 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 isn't 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 doesn't lock the table during the snapshot)4 = Concurrent_c (produces a character-mode bulk copy output of all tables but doesn't 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 - copying is disabled1 - copying 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-queued1 = Publication is queued |
options |
int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
retention_period_unit |
tinyint | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
allow_initialize_from_backup |
bit | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
min_autonosync_lsn |
varbinary(16) | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें