Drops a publication server.
sp_droppublisher publisher [, dist]
where
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.
The example drops the WOLFHOUND publication server entry.
sp_droppublisher WOLFHOUND
Execute permission defaults to the system administrator.
sysservers
sp_addpublisher | sp_dropsubscriber |
sp_addsubscriber | sp_helpdistributor |
sp_changesubscriber | sp_helpserver |
sp_dboption | sp_helpsubscriberinfo |