Renaming a stored procedure will not change definition in sql_modules - by SamCPP

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<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 432565 Comments
Status Closed Workarounds
Type Bug Repros 4
Opened 4/14/2009 9:31:14 PM
Access Restriction Public


This is similar to issue 125246 which is now closed.

In SSMS (on a SQL Server 2008 CU4 machine), if I rename a stored procedure in the object explorer, the stored procedure is renamed fine and can be called properly via other stored procs, queries and so on.

The problem is that when I query the sys.objects/sys.sql_modules, the definition of it has the OLD name for the CREATE PROCEDURE.

My server is running on a WinXP SP3 machine (SQL Server 2008 Enterprise Evaluation). My client machine is a Windows Vista SP1 machine.
Sign in to post a comment.
Posted by Microsoft on 3/29/2011 at 3:07 PM

Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this suggestion as “won’t fix”. If you feel that this is worth reconsidering, feel free to reopen it and we will take another look.

Jean-Sébastien, SQL-Server
Posted by Microsoft on 7/23/2009 at 9:13 AM

Thankyou for this bug report.

This mis-behavior has existed for some long time. We really should fix it! I've added it to our TODO list, and will try to get a fix, in between the many large projects currently underway.


Jim Hogg
Posted by Spivey on 6/22/2009 at 3:12 PM
This does terrible things when you use a compare tool like SQLCompare which runs off of SysComments. Even though the sproc is renamed, SysComments still shows the old name. Other bugs entered about this dating back to 2005 said that this would be looked at in future releases. It has not been fixed as of 2008 sp1.