sp_helpdistpublisher (T-SQL)

Returns properties of a Publisher that serves as its own Distributor.

Syntax

sp_helpdistpublisher [[@publisher =] 'publisher']

Arguments
[@publisher =] 'publisher'
Is the Publisher for which properties are returned. publisher is sysname, with a default of %.
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.
password sysname 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   Security mode implemented at the Distributor:
0 = SQL Server Authentication
1 = Windows NT 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.

Permissions

Execute permissions default to the public role.

See Also
sp_adddistpublisher sp_dropdistpublisher
sp_changedistpublisher System Stored Procedures

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.