Microsoft KB Archive/141531

{|
 * width="100%"|

INF: DocErr: The Real Meaning of 'dpub'

 * }

Q141531

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SUMMARY
In the description of the system stored procedures sp_helpserver and sp_serveroption, the SQL Server 6.0 "Books Online" lists the following values, a combination of which can describe a server:

  rpc   Remote server pub  Publication server sub  Subscription server dist Distribution server dpub Combination publisher/subscriber

However, the description for 'dpub' is incorrect; it is not used to designate a combination publisher/subscriber. Instead, the 'dpub' designation is used for a publisher on a remote server that uses the local server as a distributor. 'Combination publisher/subscriber' should be replaced with 'Remote Publisher to this Distribution server.'

MORE INFORMATION
The only other references to 'dpub' in "Books Online" are correct references within the descriptions of using the 'dist' parameter with sp_addpublisher and sp_droppublisher. For clarity, they are included below:

sp_addpublisher  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.)

sp_droppublisher  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.) Additional query words: sql6 replication docerr winnt

Keywords :

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600