INF: DocErr: The Real Meaning of 'dpub'

Last reviewed: May 2, 1997
Article ID: 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 : SSrvDoc_Err SSrvRep
Version : 6.0
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.