msdistpublishers-transact-sql.md

title	MSdistpublishers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSdistpublishers MSdistpublishers_TSQL
dev_langs	TSQL
helpviewer_keywords	MSdistpublishers system table
ms.assetid	31844099-4b33-4dc9-84b4-bac70aa82598
author	stevestein
ms.author	sstein

MSdistpublishers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md] The MSdistpublishers table contains one row for each remote Publisher supported by the local Distributor. This table is stored in the msdb database.

Column name	Data type	Description
name	sysname	The name of the Publisher Distributor.
distribution_db	sysname	The name of the distribution database.
working_directory	nvarchar(255)	The name of the working directory used to store data and schema files for the publication.
security_mode	int	The security mode implemented at the Distributor: 0 = [!INCLUDEssNoVersion] Authentication. 1 = Windows Authentication.
login	sysname	The login ID for [!INCLUDEssNoVersion] Authentication.
password	nvarchar(524)	The password (encrypted) for [!INCLUDEssNoVersion] Authentication.
active	bit	Indicates whether the local Distributor is in use by the remote Publisher.
trusted	bit	Indicates whether the remote Publisher uses the same password as the local Distributor: 0 = A password is needed at the remote Publisher to connect to the Distributor. 1 = No password is needed.
third_party	bit	Whether the Publisher is an installation of [!INCLUDEssNoVersion]: 0 = [!INCLUDEssNoVersion] installation.1 = Heterogeneous data source.
publisher_type	sysname	Publisher type: MSSQLSERVER = [!INCLUDEssNoVersion] Publisher. ORACLE = standard Oracle Publisher. ORACLE GATEWAY = Oracle Gateway Publisher.
storage_connection_string	nvarchar(779)	Value of Azure SQL Database storage connection string.

See Also

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