Removes the Subscriber designation from a registered server.
sp_dropsubscriber [@subscriber =] 'subscriber' [,[@reserved =] 'reserved']
[,[@ignore_distributor =] ignore_distributor]
0 (success) or 1 (failure)
sp_dropsubscriber is used in all types of replication.
This stored procedure removes the server sub option and removes the remote login mapping of system administrator to repl_subscriber.
Only members of the sysadmin fixed server role can execute sp_dropsubscriber.
sp_addsubscriber | sp_helpserver |
sp_changesubscriber | sp_helpsubscriberinfo |
sp_dboption | System Stored Procedures |
sp_helpdistributor |