A possible bug: renaming a stored procedure not immediately commited

Hello everybody,
did you note when you rename a stored procedure, and then open it, old name is displayed in tab?

[125 byte] By [paolod] at [2008-2-7]
# 1
How did you rename the stored procedure? Rename that by click the solution explorer item and change the name? Or open the script by Sql Editor, and change the stored proc name in the script file, or by invoke rename refactoring for the stored proc?
LiangxiaoZhu-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

That's a very good catch. It happens either via refactoring or just renaming the script directly via the SQL script.

It happens because when you create an object in the project (either through the Add New Item command or Importing a Database Schema), a file automatically gets generated on the file system. When you rename the object, we do not rename the file underneath it.

The T-SQL editor in the project system always shows the file name in the tab.

So, that's the explanation :)

Hope this helps explain why you are seeing this. If you'd like to log a bug or suggestion on this or anything else, you can do so at http://connect.microsoft.com/VisualStudio

-Tom

tomsmi at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified