How to use features of SQL Complete but retain SSMS intellisense?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
redss55
Posts: 2
Joined: Thu 18 Jul 2013 23:09

How to use features of SQL Complete but retain SSMS intellisense?

Post by redss55 » Thu 18 Jul 2013 23:11

I installed the limited free version of SQL Complete, in order to be able to execute the current statement with ctrl-shift-e.

However I would prefer to retain the stock SSMS code completion intellisense rather than SQL Complete's intellisense.

If I enable SQL Complete (for ctrl-shift-e functionality) but disable the "auto list members" checkbox in options, I am left with no intellisense at all instead of the built in SSMS intellisense.

Is there a way to use SSMS intellisense while still enabling SQL Complete to give me the "execute current statement" functionality?

alexa

Re: How to use features of SQL Complete but retain SSMS intellisense?

Post by alexa » Fri 19 Jul 2013 08:26

Unfortunately, this is not possible.

redss55
Posts: 2
Joined: Thu 18 Jul 2013 23:09

Re: How to use features of SQL Complete but retain SSMS intellisense?

Post by redss55 » Fri 19 Jul 2013 22:51

OK well something must be wrong with the behavior of my SQL Complete:

I have a table named ta. I type "select * from ta" and I notice that the SQL Complete intellisense popup has highlighted a table "JOBS_JOB_DETAILS" which has a side popup "dbo.JOBS_JOB_DETAILS (Table)"

But when I hit the space bar, it replaces "ta" with "JOBS_JOB_DETAILS" so I can't even type table names without visually checking that they are matched in the popup.

How do I fix this???

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: How to use features of SQL Complete but retain SSMS intellisense?

Post by .jp » Tue 23 Jul 2013 07:02

If the table is "ta" created in the session, it is necessary to make Refresh Local Cache from the menu
SQL Complete.
If you enter "ta" make sure that the identifier is present in the Completion List.

Post Reply