sp_droppublisher Replication Stored Procedure

Drops a publication server.

Syntax

sp_droppublisher publisher [, dist]

where

publisher
Is the name of the publication server to be dropped.
dist
Drops the server as the distribution server. (Removes the server option dpub, and removes the remote login mapping of SA to SA with the trusted option.)

Remarks

Only the system administrator can drop a publication server. If dist is not provided, the publisher's subscriber (SQL Executive) Windows NT user account has its replication privilege revoked.

Example

The example drops the WOLFHOUND publication server entry.

sp_droppublisher WOLFHOUND

Permission

Execute permission defaults to the system administrator.

Table Used

sysservers

See Also

sp_addpublisher sp_dropsubscriber
sp_addsubscriber sp_helpdistributor
sp_changesubscriber sp_helpserver
sp_dboption sp_helpsubscriberinfo