mssubscriber-info-transact-sql.md

title	MSsubscriber_info (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSsubscriber_info_TSQL MSsubscriber_info
dev_langs	TSQL
helpviewer_keywords	MSsubscriber_info system table
ms.assetid	5ca22f41-6020-4f72-8110-e69baf3447cb
caps.latest.revision	16
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSsubscriber_info (Transact-SQL)

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

The MSsubscriber_info table contains one row for each Publisher/Subscriber pair that is being pushed subscriptions from the local Distributor. This table is stored in the distribution database.

Note This system table has been deprecated and is being maintained to support previous versions of [!INCLUDEmsCoName] [!INCLUDEssNoVersion].

Definition

Column name	Data type	Description
publisher	sysname	The name of the Publisher.
subscriber	sysname	The name of the Subscriber.
type	tinyint	The subscriber type: 0 = [!INCLUDEssNoVersion] Subscriber. 1 = ODBC data source.
login	sysname	The login for [!INCLUDEssNoVersion] Authentication. Stored in encrypted format if Subscriber is added with [!INCLUDEssNoVersion] Authentication mode.
password	nvarchar(524)	The password for [!INCLUDEssNoVersion] Authentication. Stored in encrypted format if Subscriber is added with [!INCLUDEssNoVersion] Authentication mode.
description	nvarchar(255)	The description of the Subscriber.
security_mode	int	The implemented security mode: 0 = [!INCLUDEssNoVersion] Authentication. 1 = [!INCLUDEmsCoName] Windows Authentication.

See Also

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