User's Manual

sp_queue_drop procedure
Purpose To drop the stable queue objects from a database.
Syntax sp_queue_drop
See also “sp_drop_sql_remote procedure” on page 389
Description 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” on page 389.
Examples
♦ The following statements remove the stable queue objects from the
database:
sp_queue_drop
go
drop procedure sp_queue_drop
go
414