MSdistpublishers (Transact-SQL)
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. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables