Red Gate forums :: View topic - SQL Prompt 5.2.2.1 freezes the SSMS when editing SP
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt 5.2.2.1 freezes the SSMS when editing SP

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cguanes



Joined: 08 Feb 2012
Posts: 8

PostPosted: Wed Feb 08, 2012 12:38 am    Post subject: SQL Prompt 5.2.2.1 freezes the SSMS when editing SP Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Thu Feb 09, 2012 4:24 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Mar 01, 2012 7:35 pm    Post subject: I have the same FReeze issue but with table joins Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Fri Mar 09, 2012 3:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group