SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To drop the stable queue objects from a database..
sp_queue_drop
Drops the stable queue system objects from the database, so that the database no longer supports a SQL Remote stable queue.
The sole stable queue object not removed is the sp_queue_drop procedure itself (a procedure cannot drop itself from a database). To complete removal of the stable queue requires that sp_queue_drop be dropped explicitly after it is called.
The sp_queue_drop procedure does not remove SQL Remote system objects from the database. To remove the SQL Remote system objects, use the sp_drop_sql_remote procedure.
The following statements remove the stable queue objects from the database:
sp_queue_drop go drop procedure sp_queue_drop go