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.