SP_Helptext should show the renamed name. - by BHAVIN VIJAY MEHTA

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 765546 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/1/2012 6:59:00 AM
Access Restriction Public


(1)Created new procedure named My Proc

Create proc Myproc
select 1

(2) sp_rename Myproc, NewMyProc

Caution: Changing any part of an object name could break scripts and stored procedures.

(3) Now when I executed : sp_Helptext NewMyProc
 The actual Result which I got is :

Create proc Myproc
select 1

The result I was expecting was:

Create proc NewMyProc
select 1

Sign in to post a comment.
Posted by Naveen [MSFT] on 10/19/2012 at 3:08 PM
Thanks for reporting this.

sp_helptext shows the body of the proc the way it was defined. sp_rename does not change that. I can see the value of changing the body with the new name, but it is a low priority at this point.