sp_helpdistributor Replication Stored Procedure

Lists information about the distribution server, distribution database, working directory, and SQL Executive user account.

Syntax

sp_helpdistributor

Remarks

This stored procedure returns the name of the server's distribution server, the distribution database, the path of the distribution working directory, and the name of the Windows NT user account that the distribution process runs under. If the distribution database is not installed, a null value is returned.

Example

This example displays distribution information.

sp_helpdistributor

Permission

Execute permission defaults to the public group.

Table Used

sysservers

See Also