Lists information about the Distributor, distribution database, working directory, and SQL Server Agent user account.
sp_helpdistributor [[@distributor =] 'distributor' OUTPUT]
[,[@distribdb =] 'distribdb' OUTPUT]
[,[@directory =] 'directory' OUTPUT]
[,[@account =] 'account' OUTPUT]
[,[@min_distretention =] min_distretention OUTPUT]
[,[@max_distretention =] max_distretention OUTPUT]
[,[@history_retention =] history_retention OUTPUT]
[,[@history_cleanupagent =] 'history_cleanupagent' OUTPUT]
[,[@distrib_cleanupagent =] 'distrib_cleanupagent' OUTPUT]
[,[@publisher =] 'publisher'] [,[@local =] 'local']
[,[@rpcsrvname =] 'rpcsrvname' OUTPUT]
Column name | Data type | Description |
---|---|---|
distributor | sysname | Name of the Distributor |
distribution database | sysname | Name of the distribution database |
directory | nvarchar(255) | Name of the working directory |
account | nvarchar(255) | Name of the Microsoft Windows NT® user account |
min distrib retention | int | Minimum distribution retention period |
max distrib retention | int | Maximum distribution retention period |
history retention | int | History retention period |
history cleanup agent | nvarchar(100) | Name of the History Cleanup Agent |
distribution cleanup agent | nvarchar(100) | Name of the Distribution Cleanup Agent |
rpc server name | sysname | Name of the remote or local Distributor |
rpc login name | sysname | Login used for remote procedure calls to the remote Distributor |
If the distribution database is not installed, a NULL value is returned.
sp_helpdistributor is used in all types of replication.
Execute permissions default to the public role.
sp_adddistpublisher | sp_dropsubscriber |
sp_addsubscriber | sp_helpserver |
sp_changesubscriber | sp_helpsubscriberinfo |
sp_changesubstatus | System Stored Procedures |
sp_dboption |