sp_helpdistpublisher (Transact-SQL)

 

Applies To: SQL Server

Returns properties of the Publishers using a Distributor. This stored procedure is executed at the Distributor on any database.

Topic link icon 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
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Column nameData typeDescription
namesysnameName of Publisher.
distribution_dbsysnameDistribution database for the specified Publisher.
security_modeintSecurity mode used by replication agents to connect to the Publisher for queued updating subscriptions, or with a non-SQL Server Publisher.

 0 = SQL Server Authentication

 1 = Windows Authentication
loginsysnameLogin name used by replication agents to connect to the Publisher for queued updating subscriptions, or with a non-SQL Server Publisher.
passwordnvarchar(524)Password returned (in simple encrypted form). Password is NULL for users other than sysadmin.
activebitWhether a remote Publisher is using the local server as a Distributor:

 0 = No

 1 = Yes
working_directorynvarchar(255)Name of the working directory.
trustedbitIf the password is required when the Publisher connects to the Distributor. For Microsoft SQL Server 2005 and later versions, this should always return 0, which means that the password is required.
thirdparty_flagbitWhether the publication is enabled by SQL Server or by a third party application:

 0 = SQL Server, Oracle, or Oracle Gateway Publisher.

 1 = Publisher has been integrated with SQL Server using a third-party application.
publisher_typesysnameType of Publisher; can be one of the following:

 MSSQLSERVER

 ORACLE

 ORACLE GATEWAY
publisher_data_sourcenvarchar(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)

Community Additions

ADD
Show: