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. To change the name of an ESP:
Use drop procedure or sp_dropextendedproc to remove the ESP.
Rename and recompile the supporting function.
create procedure or sp_addextendedproc to re-create the ESP, assigning to it the new name.
