Red Gate forums :: View topic - SQL Prompt versus SSMS 2012 intellisense
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 versus SSMS 2012 intellisense

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



Joined: 13 Mar 2012
Posts: 20

PostPosted: Fri May 24, 2013 7:31 pm    Post subject: SQL Prompt versus SSMS 2012 intellisense Reply with quote

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?

Thanks,

John
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue May 28, 2013 11:00 am    Post subject: Reply with quote

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-development/sql-prompt/feature-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
Back to top
View user's profile Send private message Send e-mail
freecell1



Joined: 13 Mar 2012
Posts: 20

PostPosted: Tue May 28, 2013 4:34 pm    Post subject: Reply with quote

Thanks Chris. Turning off auto-list members on SSMS options fixed my problem.
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Tue May 28, 2013 7:14 pm    Post subject: Reply with quote

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

Cheers, to you, too...!
Back to top
View user's profile Send private message
damcis



Joined: 14 Feb 2008
Posts: 10

PostPosted: Tue Jul 16, 2013 4:41 pm    Post subject: Reply with quote

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!!
_________________
Dan
Back to top
View user's profile Send private message
steveculshaw



Joined: 02 Jun 2009
Posts: 11

PostPosted: Wed Aug 21, 2013 1:08 pm    Post subject: Thank you Reply with quote

Glad I found this post as I was getting very confused with multiple boxes appearing ...
_________________
Cheers,
SteveC.
Back to top
View user's profile Send private message
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