Red Gate forums :: View topic - SQL Prompt 6 stops suggesting table names
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt 6 stops suggesting table names

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
andyhammer



Joined: 08 Aug 2013
Posts: 5

PostPosted: Mon Nov 18, 2013 10:42 pm    Post subject: SQL Prompt 6 stops suggesting table names Reply with quote

In SSMS 2008, prompt will stop making table name suggestions. The drop down does not even show the tables. I always have multiple tabs open. Some tabs will work fine, others do not. Closing/opening a file does not fix the issue. The only way I have found to fix this is to restart SSMS. Sad
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Wed Nov 20, 2013 3:38 pm    Post subject: Reply with quote

Thanks for your post.

Can you try the latest version of SQL Prompt 6.1.0.101? Hopefully this version should sort this issue.

You can get this version by navigating to SQL Prompt --> Help --> Check for updates.

Let me know if this helps.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
andyhammer



Joined: 08 Aug 2013
Posts: 5

PostPosted: Wed Nov 20, 2013 4:14 pm    Post subject: Reply with quote

I will install the update.
Back to top
View user's profile Send private message
pswaters



Joined: 02 Dec 2013
Posts: 3

PostPosted: Mon Dec 02, 2013 10:15 pm    Post subject: Reply with quote

I am having a very similar issue with 6.1.0.101. I am refactoring a few queries that have several joins. SQL Prompt works as expected for 6 to 12 joins, and then stops suggesting tables and columns. The queries work and SQL Prompt will format them without any errors.

If I press <crtl> - <space> I get a list of code snippets and nothing else.

Thanks.
_________________
Paul S. Waters
Back to top
View user's profile Send private message
pswaters



Joined: 02 Dec 2013
Posts: 3

PostPosted: Mon Dec 02, 2013 10:32 pm    Post subject: Reply with quote

I un-installed version 6.1.0.101 and installed version 5.2.8.2, and I still have the same issues. I am guessing that there is something in my queries that SQL Prompt does not like, but I cannot find it.

Any suggestions?

Thanks.
_________________
Paul S. Waters
Back to top
View user's profile Send private message
pswaters



Joined: 02 Dec 2013
Posts: 3

PostPosted: Tue Dec 03, 2013 12:24 am    Post subject: Reply with quote

I am back on version 6.1.0.101 and I have a work a round for the issue. I noticed that when I deleted some comments above where IntilliPrompt stopped making suggestions for joined columns, it started to work for another join or 2. So deleted all but a couple of columns in my select statement, and now IntilliPrompt works as expected for the joins.

Is there a limit to the size of the query for intelliprompt to work?

Thanks.
_________________
Paul S. Waters
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Tue Dec 03, 2013 12:12 pm    Post subject: Reply with quote

If you wish to alter the behaviour of SQL Prompt where it does not suggest variables over large blocks of SQL or fails to provide help with large scripts, you can edit the RedGate_SQLPrompt_Engine_EngineOptions.xml file.

This file should be in the below location:

%USERPROFILE%\AppData\Local\Red Gate\SQL Prompt 6

The string in the file you need to edit is <ParserLookBackDistance>5000</ParserLookBackDistance><ParserLookAheadDistance>3000</ParserLookAheadDistance>

The figure detailed here is in bytes. You can increase the look back distance as much as you like. However please be aware that, depending on your hardware, there may be a considerable degradation in the performance of the tool.

Please let me know if that helps.
_________________
Anuradha Deshpande
Product Support
Redgate 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