What are the challenges you face when working across database platforms? Take the survey

SQL Prompt 5 hangs SSMS 2008 R2

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 :

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


  • Options
    Sorry you are experiencing this.
    This is a known issue under the internal reference number of SP-4639.
    I have added your details to the existing request.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.