SQL Prompt 5 hangs SSMS 2008 R2

Provides intelligent code completion for SQL Server editors.

SQL Prompt 5 hangs SSMS 2008 R2

Postby jim.young@pearson.com » Tue Mar 19, 2013 6:47 pm

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
Posts: 1
Joined: Tue Mar 19, 2013 6:41 pm

Postby Manfred.Castro » Thu Mar 21, 2013 5:51 pm

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
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests