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.


1
0
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

Description

(1)Created new procedure named My Proc

Create proc Myproc
as
select 1

(2) sp_rename Myproc, NewMyProc

Result:
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
as
select 1

The result I was expecting was:

Create proc NewMyProc
as
select 1





Sign in to post a comment.
Posted by Microsoft 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.