SQL Prompt 5.2.2.1 freezes the SSMS when editing SP

Provides intelligent code completion for SQL Server editors.

SQL Prompt 5.2.2.1 freezes the SSMS when editing SP

Postby cguanes » Wed Feb 08, 2012 12:38 am

I have a SP that every time that I have to edit it, I need to turn the SQL Prompt off or my SSMS will freeze.

The SP use a lot of temporary table (#table) and parsing XML.

Is this a known issue? Any patch for it?
Carlos Guanes
cguanes
 
Posts: 8
Joined: Wed Feb 08, 2012 12:28 am

Postby eddie davis » Thu Feb 09, 2012 4:24 pm

Thank you for your post into the forum.

I have known when working with a large script that performance falls off when away from the caret.

So I can reproduce the error, would it be possible to get a copy of your SP?

A support call has been created for you, the call reference number is F0057164. If you could please attached a copy of your SP as a text file to an e-mail, I can then modify it to see if I can reproduce your error. Also if you can include in the e-mail, the version of SQL Server you are using?

Please send the e-mail to support@red-gate.com and include the call reference number in the subject field of the e-mail.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 998
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

I have the same FReeze issue but with table joins

Postby EdCarden » Thu Mar 01, 2012 7:35 pm

I too experience a freeze or lockup of SSMS (versin 2008 R2) when SQL Prompt is enabled but mine occurs when I am typing in a table join and get the keyword ON. After the N in ON is typed SSMS freezes and is unresposive for several seconds and sometime may take 10-15 seconds or more.

The only consistency I can find is that its the first instance of ON following the listing of 2 tables in the FROM clause. The next table joins all occur with no issue and no freeze. I thought the probelm was with a specific table but additional testing just now showed me its always the first table join that does this.

EXAMPLE:

SELECT A.*, B.*
FROM TABLEA A Join TABLEB B ON

AT this point, after typing ON SSMS will freeze up.

I have not tested this with SP's myself.
EdCarden
 
Posts: 98
Joined: Tue Nov 25, 2008 6:26 pm

Postby eddie davis » Fri Mar 09, 2012 3:55 pm

A bug report has been submitted for the SQL Prompt Development Team to consider. The reference for this Bug Report is SP-4282. At this time the bug is being investigated and therefore unresolved.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 998
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests