| title | sp_helpdistpublisher (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | f207c22d-8fb2-4756-8a9d-6c51d6cd3470 | ||
| caps.latest.revision | 37 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns properties of the Publishers using a Distributor. This stored procedure is executed at the Distributor on any database.
Transact-SQL Syntax Conventions
sp_helpdistpublisher [ [ @publisher=] 'publisher']
[ , [ @check_user = ] check_user
[ @publisher= ] 'publisher'
Is the Publisher for which properties are returned. publisher is sysname, with a default of %.
[ @check_user= ] check_user
[!INCLUDEssInternalOnly]
| Column name | Data type | Description |
|---|---|---|
| name | sysname | Name of Publisher. |
| distribution_db | sysname | Distribution database for the specified Publisher. |
| security_mode | int | Security mode used by replication agents to connect to the Publisher for queued updating subscriptions, or with a non-[!INCLUDEssNoVersion] Publisher. 0 = [!INCLUDEssNoVersion] Authentication 1 = Windows Authentication |
| login | sysname | Login name used by replication agents to connect to the Publisher for queued updating subscriptions, or with a non-[!INCLUDEssNoVersion] Publisher. |
| password | nvarchar(524) | Password returned (in simple encrypted form). Password is NULL for users other than sysadmin. |
| active | bit | Whether a remote Publisher is using the local server as a Distributor: 0 = No 1 = Yes |
| working_directory | nvarchar(255) | Name of the working directory. |
| trusted | bit | If the password is required when the Publisher connects to the Distributor. For [!INCLUDEmsCoName] [!INCLUDEssVersion2005] and later versions, this should always return 0, which means that the password is required. |
| thirdparty_flag | bit | Whether the publication is enabled by [!INCLUDEssNoVersion] or by a third party application: 0 = [!INCLUDEssNoVersion], Oracle, or Oracle Gateway Publisher. 1 = Publisher has been integrated with [!INCLUDEssNoVersion] using a third-party application. |
| publisher_type | sysname | Type of Publisher; can be one of the following: MSSQLSERVER ORACLE ORACLE GATEWAY |
| publisher_data_source | nvarchar(4000) | Name of the OLE DB data source on the Publisher. |
0 (success) or 1 (failure)
sp_helpdistpublisher is used in all types of replication.
sp_helpdistpublisher will not display the publisher login or password in the result set for non-sysadmin logins.
Members of the sysadmin fixed server role may execute sp_helpdistpublisher for any Publisher using the local server as a Distributor. Members of the db_owner fixed database role or the replmonitor role in a distribution database may execute sp_helpdistpublisher for any Publisher using that distribution database. Users in the publication access list for a publication at the specified publisher may execute sp_helpdistpublisher. If publisher is not specified, information is returned for all Publishers that the user has rights to access.
View and Modify Distributor and Publisher Properties
sp_adddistpublisher (Transact-SQL)
sp_changedistpublisher (Transact-SQL)
sp_dropdistpublisher (Transact-SQL)