You can remove an ESP from the database using either drop procedure or sp_dropextendedproc.
The syntax for drop procedure is the same as for stored procedures:
drop procedure [owner.]procedure_name
The following command drops xp_echo:
drop procedure xp_echo
The syntax for sp_dropextendedproc is:
sp_dropextendedproc esp_name
For example:
sp_dropextendedproc xp_echo
Both methods drop the ESP from the database by removing references to it in the sysobjects and syscomments system tables. They have no effect on the underlying DLL.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
