msreplication-subscriptions-transact-sql.md

title	MSreplication_subscriptions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	MSreplication_subscriptions MSreplication_subscriptions_TSQL
dev_langs	TSQL
helpviewer_keywords	MSreplication_subscriptions system table
ms.assetid	fd0c5843-4e9b-4448-8bfb-0a4067d1d8d1
caps.latest.revision	27
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSreplication_subscriptions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)