MSdistpublishers (Transact-SQL)

Applies to: SQL Server

The MSdistpublishers table contains one row for each Publisher supported by the Distributor. This table is located in the msdb database on the Distributor.

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 = SQL Server Authentication. 1 = Windows Authentication.
login	sysname	The login ID for SQL Server Authentication.
password	nvarchar(524)	The password (encrypted) for SQL Server 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 SQL Server: 0 = SQL Server installation. 1 = Heterogeneous data source.
publisher_type	sysname	Publisher type: MSSQLSERVER = SQL Server Publisher. ORACLE = standard Oracle Publisher. ORACLE GATEWAY = Oracle Gateway Publisher.
storage_connection_string	nvarchar(779)	Value of Azure SQL Database storage connection string.

Related content

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