INF: Stored Proc to Remove Replication Info

 Last reviewed: August 14, 1997
Article ID: Q171913
The information in this article applies to:
  • Microsoft SQL Server versions 6.0 and 6.5

This article describes how to obtain Sqlunpub.exe, which contains a stored procedure that can be used to remove replication related information from a database that has been loaded from a dump of a published database. This procedure will remove publication/subscription information stored in the database, along with marking published objects as unpublished and will remove any transactions marked for replication in the transaction log.

FILES AVAILABLE FROM ONLINE SERVICES

The following file is available for download from the Microsoft Software Library: 

 ~ Sqlunpub.exe (size: 18396 bytes)
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services
The files in the MSL are compressed, self-extracting executables. After you download the file you need, simply run it to extract the files it contains. Note that the expanded file contains the following files: 

   Repl65_4.sql - stored procedure
   Readme.txt - installation and usage instructions
If you need more information or assistance regarding this application, please contact your primary support provider.

Additional query words: sql6 utility
Keywords : SSrvGen kbfile
Version : WINDOWS: 6.0, 6.5
Platform : WINDOWS
Issue type : kbhowto
Solution Type : kbfile

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: August 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.