sp_helpsubscriberinfo Replication Stored Procedure

For SQL Server 6.5 information, see sp_helpsubscriberinfo in What's New for SQL Server 6.5.

Displays information about a subscription server.

Syntax

sp_helpsubscriberinfo subscriber

where

subscriber
Is the name of the subscription server.

Remarks

This stored procedure displays information about the parameters set by sp_addsubscriber.

Example

This example displays information about the subscription server WOLFHOUND.

sp_helpsubscriberinfo WOLFHOUND

Permission

Execute permission defaults to the system administrator.

Table Used

sysservers

See Also

sp_addpublisher sp_droppublisher
sp_addsubscriber sp_dropsubscriber
sp_changesubscriber sp_helpdistributor
sp_dboption sp_helpserver