Remove ESPs

To remove an ESP from the database, use either drop procedure or sp_dropextendedproc.

The syntax for drop procedure is the same as for stored procedures:

drop procedure [owner.]procedure_name

For example:

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.

• Renaming ESPs
  Because an ESP name is bound to the name of its function, you cannot rename an ESP using sp_rename, as you can with a stored procedure.