Data Replication with SQL Remote

Home

Upgrading SQL Remote for Adaptive Server Enterprise

Chapter 4: A Tutorial for Adaptive Server Anywhere Users

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:

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

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

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:

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

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

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

drop procedure sp_queue_drop
go


	Expand Search