.png)
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. |
