MSreplication_subscriptions (Transact-SQL)
The MSreplication_subscriptions table contains one row of replication information for each Distribution Agent servicing the local Subscriber database. This table is stored in the subscription database.
| Column name | Data type | Description |
|---|---|---|
publisher |
sysname |
The name of the Publisher. |
publisher_db |
sysname |
The name of the Publisher database. |
publication |
sysname |
The name of the publication. |
independent_agent |
bit |
Indicates whether there is a stand-alone Distribution Agent for this publication. |
subscription_type |
int |
The type of subscription: 0 = Push. 1 = Pull. 2 = Anonymous. |
distribution_agent |
sysname |
The name of the Distribution Agent. |
Time |
smalldatetime |
The time of the last update by Distribution Agent. |
description |
nvarchar(255) |
The description of the subscription. |
transaction_timestamp |
varbinary(16) |
Internal-use only. |
update_mode |
tinyint |
The type of update. |
agent_id |
binary(16) |
The ID of the agent. |
subscription_guid |
binary(16) |
The global identifier for the version of the subscription on the publication. |
subid |
binary(16) |
The global identifier for an anonymous subscription. |
immediate_sync |
bit |
Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs. |
See Also
Reference
Replication Views (Transact-SQL)
sp_helpsubscription (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)