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.