Devart Forums

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?

Unfortunately, this is not possible.

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???

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.