INF: Stored Proc to Remove Replication Info From DB Loaded From Dump of Published Database

ID: Q171913

The information in this article applies to:

Microsoft SQL Server versions 6.0, 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

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

Q119591 : 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 : kbfile SSrvGen SSrvRep
Version : WINDOWS: 6.0, 6.5
Platform : WINDOWS
Issue type : kbhowto