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.

1. Use drop procedure or sp_dropextendedproc to remove the ESP.
2. Rename and recompile the supporting function.
3. create procedure or sp_addextendedproc to re-create the ESP, assigning to it the new name.