Data Replication with SQL Remote
   PART 1. Introduction to SQL Remote
     CHAPTER 3. Setting Up SQL Remote       

Uninstalling SQL Remote

This section describes how to uninstall the SQL Remote objects from a database, and uninstall the stable queue from a database.

  To uninstall the SQL Remote objects from a database:

1. Connect to the database containing the SQL Remote objects, as a user with dbo permissions.

2. Run the sp_drop_sql_remote stored procedure to remove all SQL Remote objects apart from the procedure itself. The sp_drop_sql_remote procedure is installed along with the other SQL Remote objects.

   exec sp_drop_sql_remote
   go

3. Drop the sp_drop_sql_remote procedure to complete the uninsall procedure.

   drop procedure sp_drop_sql_remote
   go

  To uninstall the stable queue from a database:

1. Connect to the database containing the stable queue, as a user with dbo permissions.

2. Run the sp_queue_drop stored procedure to remove all stable queue objects apart from the procedure itself. The sp_queue_drop procedure is installed along with the other stable queue objects.

   exec sp_queue_drop
   go

3. Drop the sp_queue_drop procedure itself, to complete the uninstall procedure.

   drop procedure sp_queue_drop
   go