SQL Remote User's Guide
  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

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.

Example 

• The following statements remove SQL Remote system objects from a database:

  sp_drop_SQL_remote_type
  go
  drop procedure sp_drop_SQL_remote
  go