I am using Microsoft SSMS (SQL Server Management Studio) 2008. When I have the Object Explorer open and browse to the Programmability > Stored Procedures folder. If you right click on a stored proc and click Modify it opens the stored proc in a new window.
But then when you go back to Object Explorer it has now refreshed and it shows the root folder of the database I am on (it didn't stay on the Stored Procedures folder). If you right click on the stored proc and click Script Stored Procedure as > Alter To > New Query Window. It doesn't seem to do this. The Object Explorer stays on the same Stored Procedures folder.
Is there a way to make the Modify Stored Proc not refresh the Object Explorer? I don't remember this ever happening in SSMS 2005.