Returns properties of a Publisher that serves as its own Distributor.
sp_helpdistpublisher [[@publisher =] 'publisher']
| 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 |
sp_helpdistpublisher is used in all types of replication.
Execute permissions default to the public role.
| sp_adddistpublisher | sp_dropdistpublisher |
| sp_changedistpublisher | System Stored Procedures |