MSreplication_subscriptions (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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

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