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:
Remove the ESP with drop procedure or sp_dropextendedproc.
Rename and recompile the supporting function.
Re-create the ESP with the new name using create procedure or sp_addextendedproc.
