User's Manual

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 uninstall
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
26