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