MSdistpublishers (Transact-SQL)
Applies to: 
SQL Server
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 = 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. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)