MSreplication_subscriptions (Transact-SQL)

Applies to: SQL Server

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)