sp_addpublisher Replication Stored Procedure

Adds a new publication server.

Syntax

sp_addpublisher publisher [, 'dist']

where

publisher

Is the name of the server to be added.

dist

Defines the specified server as a potential publisher to this distribution server. This is true if the local server is set up with a distribution database. (Sets the server option to dpub, and adds a remote login mapping of SA to SA with the trusted option.)

Remarks

If 'dist' is not specified the publisher's distributor (SQL Executive) user account will be granted repl privilege. Only the system administrator can add a server to master.sysservers as a publication server.

Example

This example adds the publication server WOLFHOUND and defines it as a potential publisher.

sp_addpublisher WOLFHOUND, 'dist'

Permission

Execute permission defaults to the system administrator.

Table Used

sysservers

See Also