User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise

sp_drop_sql_remote procedure

Purpose To drop the SQL Remote system objects from a database.

Syntax sp_drop_sql_remote

See also “sp_queue_drop procedure” on page 414

Description Drops the SQL Remote system objects from the database, so that it can no

longer function in a SQL Remote installation.

The sole SQL Remote object not removed is the sp_drop_sql_remote

procedure itself (a procedure cannot drop itself from a database). To

complete removal of SQL Remote requires that sp_drop_sql_remote be

dropped explicitly after it is called.

The sp_drop_sql_remote procedure does not remove stable queue objects

from the database. To remove the stable queue, use the “sp_queue_drop

procedure” on page 414.

Example

♦ The following statements remove SQL Remote system objects from a

database:

sp_drop_sql_remote_type

drop procedure sp_drop_sql_remote

389