Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_helpdistpublisher

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Returns properties of a Publisher that serves as its own Distributor. This stored procedure is executed at the Distributor on any database.

Syntax

sp_helpdistpublisher [ [ @publisher =] 'publisher']
    [ , [ @check_user = ] check_user

Arguments

[@publisher = ] 'publisher'

Is the Publisher for which properties are returned. publisher is sysname, with a default of %.

[@check_user = ] check_user

For internal use only.

Result Sets
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 the replication agent in a push subscription to connect to the Publisher.
login sysname Login name used by the replication agent in a push subscription to connect to the Publisher. Login name is returned as NULL for users other than sysadmin.
password sysname Password returned (in simple encrypted form). Password is returned as 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 Security mode implemented at the Distributor:

0 = SQL Server Authentication
1 = Windows Authentication

thirdparty_flag bit Whether the publication is a Microsoft® SQL Server™ database:

0 = Microsoft SQL Server
1 = Data source other than Microsoft SQL Server


Remarks

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.

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, or the replmonitor role in the distribution database can execute sp_helpdistpublisher.

See Also

Replication Monitor

sp_adddistpublisher

sp_changedistpublisher

sp_dropdistpublisher

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.