SQL Prompt versus SSMS 2012 intellisense

Provides intelligent code completion for SQL Server editors.

SQL Prompt versus SSMS 2012 intellisense

Postby freecell1 » Fri May 24, 2013 6:31 pm

Hi folks -

I just installed SSMS 2012. I've been using SQL PRompt 5 with SSMS 2008 R2 until now and like it. However in SSMS 2012 Microsoft seems to have improved the internal intellisense. Also both the intellisense and SQL Prompt are on by default so I have two layered suggestion boxes popping up. Can someone clarify how SQL Prompt differs from the built-in offering?


Posts: 25
Joined: Tue Mar 13, 2012 7:21 pm

Postby Chris Auckland » Tue May 28, 2013 10:00 am

Thanks for your post.

SQL Prompt 5 should be able to co-exist with the native intellisense. There are a few features (like parenthesis matching) that the native tool supports that we don't, so they can both be enabled.

However, the candidate list pop-up should only be enabled for one of them, or they will interfere with each other.

It sounds like for some reason Tools > Options > Text Editor > Transact SQL > General > Auto list members is still enabled, which would cause the native list to pop-up as well.

The main advantage over the native intelisense is the additional formatting and non-code completion features: http://www.red-gate.com/products/sql-de ... ure-matrix

There is also advantages in the way SQL Prompt makes suggestions for code completion, but I have to say I'm not entirely sure how sophisticated the native intelisense has become to confirm if we still have an advantage in that area.

I hope this helps.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Postby freecell1 » Tue May 28, 2013 3:34 pm

Thanks Chris. Turning off auto-list members on SSMS options fixed my problem.
Posts: 25
Joined: Tue Mar 13, 2012 7:21 pm

Postby PDinCA » Tue May 28, 2013 6:14 pm

Priceless comments, Chris and @freecell1. Just what I needed to enjoy the best of both worlds.

Cheers, to you, too...!
Posts: 582
Joined: Mon Jul 25, 2005 10:42 pm
Location: Irvine, CA, USA

Postby damcis » Tue Jul 16, 2013 3:41 pm

Totally agree. I've been fighting with the two lists displaying at the same time and it was aggravating. I wanted the red error lines, but didn't want the list from intellisense, wanted it from Sql prompt. Thanks for pointing out how to disable the intellisense list!!
Posts: 10
Joined: Thu Feb 14, 2008 2:24 pm

Thank you

Postby steveculshaw » Wed Aug 21, 2013 12:08 pm

Glad I found this post as I was getting very confused with multiple boxes appearing ...
Posts: 13
Joined: Tue Jun 02, 2009 8:37 am

SSMS 2012 w7 x64

Postby auris1 » Fri Aug 22, 2014 9:17 am

I have installed the SQL prompt for the user, but the addin not appearing at all,user have SSMS 2012 w7 x64

for his colleage SSMS 2010 w7 x64 working just fine

Have checked the location c:\\Program Files (x86)\\Red Gate\\SQL Prompt 5

both machine have exacly the same files, do you have any advice how we can enable addin on version of SSMS 2012?
Posts: 1
Joined: Fri Aug 22, 2014 9:07 am

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests