SSMS 2008 modify stored procedure refreshes Object Explorer -
I am using Microsoft SSMS (SQL Server Management Studio) 2008. When I have an object explorer and browse programmability> stored procedure folder. If you right-click on a stored proc and click Modify it opens the proc stored in a new window.
But then when you go back to the object explorer, it has now been refreshed and it shows the root folder of the database that I am doing (it was not on the stored process folder). If you right-click on the stored proc and click the script> Structured Process as> New Query Window, it does not appear to do so Object Explorer stays on the same stored procedure folder.
Is there a way to refresh the revised collection process in Object Explorer? I do not remember that this is happening in SSMS 2005.