SQL Server 2008 Management Studio open file dialog not responding
sql-server, sql-server-2008, windows-7-x64
Solution
If you have any network share, remove it and try.
Probably, Open file dialog is stuck at one of the mapped drive?
Also, check https://dba.stackexchange.com/questions/20725/sql-server-management-studio-slow-opening-new-windows
Hope that helps. PS: Have you installed latest SP?
Problem
I am having problems opening files in SQL Server Management Studio. I can connect fine to the local database (SQL Server std. 2008 R2), but when I do File > Open > Open File, the dialog just hangs until it says 'Not Responding'. It does eventually connect, but hangs for a period of 20-30 seconds to navigate between each folder on the local network. I do not have the same problem navigating the same folders with windows explorer or Visual Studio 2012. It seems that this only occurs with SQL Server Management Studio. I have tried to find a thread to find a resolution, but the only thread I did find had the link removed to the solution!