My questions seem to be unrelated BUT Windows Explorer might be causing the problem I see when I use SQL Management Studio (Windows 7 64-bit).
a. Recently, since 2 weeks or so ago, my Windows Explorer became less responsive: I can do a copy and paste of a folder for example and do not see the change in W. E. right away. I have to do a manual refresh of the folder to see the change.
b. Now when I rename a database in the MS SQL Management Studio, the underlying database name is NOT changed, even though the name in the Object Explorer is! Before the name of the mdf file was changed by the M.S. When I try to rename the file manually, I get the msg saying "The action can't be completed because the file is open in SQL Server (MSSQLSERVER).
So my question is How do I shut down the SQL Server? I actually shutdown the PC and restarted then try to rename the database file but the same error msg shows up: file is open in SQL Server!
Thanks for any pointer.