Options
SQL Prompt 5 hangs SSMS 2008 R2
jim.young@pearson.com
Posts: 2
While laying out SQL in a SQL Server Management Studio 2008 R2 window today, SSMS completely hung. The script I tried to lay out was missing a closing quote. It looked like this generic SQL:
UPDATE table SET Column1 = '2013-03-06 5:00', Column2 = '2013-03-06 5:00 WHERE ID = 123
I hit Ctrl+K, Ctrl+Y and the window hung with the "Reformatting Keywords..." dialog on top. I can click the Cancel button, but nothing happens. SSMS does not respond in any way, but Windows doesn't show it as "Not Responding". I have to end task to close it.
SQL Prompt version : 5.3.6.28
SSMS Help>About info:
Microsoft SQL Server Management Studio 10.50.1797.0
Microsoft Analysis Services Client Tools 10.50.1797.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4984
Operating System 6.1.7600
UPDATE table SET Column1 = '2013-03-06 5:00', Column2 = '2013-03-06 5:00 WHERE ID = 123
I hit Ctrl+K, Ctrl+Y and the window hung with the "Reformatting Keywords..." dialog on top. I can click the Cancel button, but nothing happens. SSMS does not respond in any way, but Windows doesn't show it as "Not Responding". I have to end task to close it.
SQL Prompt version : 5.3.6.28
SSMS Help>About info:
Microsoft SQL Server Management Studio 10.50.1797.0
Microsoft Analysis Services Client Tools 10.50.1797.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4984
Operating System 6.1.7600
Comments
This is a known issue under the internal reference number of SP-4639.
I have added your details to the existing request.
Product Support
Red Gate Software