sp_dropsubscriber Replication Stored Procedure

Drops a subscription server.

Syntax

sp_dropsubscriber subscriber

where

subscriber

Is the name of the subscription server to be dropped.

Remarks

This stored procedure removes the server sub option and removes the remote login mapping of SA to repl_subscriber. Only the system administrator can drop a subscription server.

Example

This example drops the subscription server BLOODHOUND.

sp_dropsubscriber BLOODHOUND

Permission

Execute permission defaults to the system administrator.

Tables Used

sysservers, sysremotelogins

See Also