Tuesday, September 13, 2011 4:58 PMThis originally felt like it could be a problem with MMC or Windows 7, but I've tried other MMCs and it only happens with SQL Server Management Studio.Under the following conditions:
The Save As dialog vanishes and all of the UI elements in the MDI frame stop responding.
- Run Management Studio 2008 as an administrator.
- Connect to any SQL server instance (we're using Windows authentication and the administrative account has sysadmin privileges in the instance).
- Script an object to a new query window (I scripted a CREATE and DROP for a user table)
- Run Save As...
- Click on the tree dropdown at the top of the dialog that appears.
- The dialog is nowhere to be found.
- You can do things in the docked windows (e.g. object explorer), even close them, but you can't edit the scripts and you can't exit Management Studio.
- If you try to close the application through the system menu, you get a dialog that says "Microsoft SQL Server management studio cannot shut down because a modal dialog is active." The only way to close Management Studio is to kill it using Task Manager.
- This does not happen if you run Management studio as a non-administrator. You can use RunAs with a different non-administrative user and the problem does not appear. I also logged into the desktop with the administrative account and the above steps did not cause the problem if I didn't elevate with "run as administrator".
- Edited by Spencer Simpson Tuesday, September 13, 2011 5:09 PM restricted scope of problem
Saturday, September 17, 2011 12:00 PMModerator
Hi Spencer Simpson,
Could you please check that the lasted service packages have been applied to the Window 7 operating system and SQL Server 2008?
Get the latest service pack for your version of Windows:
Get the latest service pack for your version of SQL Server: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact email@example.com.
- Proposed As Answer by Stephanie LvModerator Wednesday, September 21, 2011 12:46 PM
- Unproposed As Answer by Spencer Simpson Wednesday, September 21, 2011 1:08 PM
- Marked As Answer by Spencer Simpson Wednesday, September 21, 2011 1:10 PM
- Unmarked As Answer by Spencer Simpson Wednesday, September 21, 2011 1:12 PM
Wednesday, September 21, 2011 1:18 PMNope, didn't solve the problem. My WSUS server says that my computer has all applicable updates installed, and that SQL Server 2008 R2 Service Pack 2 is "Installed". The only component of SQL Server 2008 R2 installed is Management Studio Express (10.50.1617.0).
- Edited by Spencer Simpson Wednesday, September 21, 2011 2:12 PM
Thursday, September 22, 2011 1:23 PMJust today, Automatic Updates decided that SQL Server 2008 (not R2) Service pack 2 was needed, and so that got installed, and now Management Studio is up to 10.50.2500.0. Same problem, however.
Wednesday, October 19, 2011 3:59 PMI am having the same problem - Windows 7 operating system, with SQL Server 2008 R2 Management Studio installed. I am fully patched.
Wednesday, November 02, 2011 1:42 PMI have the same setup and the same problem. Has anyone heard anything new on this issue?
Wednesday, November 16, 2011 2:55 PM
Automatic Updates installed SQL Server 2008 Service pack 3 but didn't change the build number of the management studio.
The update did not solve the problem and I'm not surprised. This is more likely a problem with Windows 7 rather than SQL Server; unfortunately, this is the only place I can get it to happen.
Wednesday, April 25, 2012 6:21 PMSo I guess Microsoft is just choosing to ignore this error and its customers who are unproductively losing work as they continue to encounter it?
Wednesday, December 05, 2012 3:10 PM
I too am having this issue with SQL Server Management Studio (SSMS) on Windows 7 Pro.
It's odd to me that the dialog itself has no unique presence in the task manager. The desired workaround would be to in some way recall or re-establish this dialog. Not sure if it's commdlg.dll or other library causing the issue but has only started happening after about a month of usage on my system. (2.5GHz i5 proc, 4GB RAM, Windows 7 Ver 6.1.7601 32-bit, .Net ver 2.0.50727.5466, IE ver 9.0.8112.16421, SSMS 10.50.2500.0)
Tuesday, January 15, 2013 7:40 PMWe keep Windows pretty aggressively patched, and one Windows Update or another has cleared up the problem. It could have been any one of hundreds of updates, in the Win7 kernel, the shell, the .NET framework, or even SQL.
- Marked As Answer by Spencer Simpson Tuesday, January 15, 2013 7:41 PM