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

Page 432
Image 432
Sybase DC38133-01-0902-01 manual Spqueuedrop procedure, Spdropsqlremote procedure on