Wrong Suggestion Inserted

MikeyC

I am running version 4.0.4.21 and have found that in some case SQL Prompt will insert a suggestion other than I have selected.

SELECT 
	*,
	COUNT(DI<cursor>
FROM msdb.dbo.backupfile

If at that point I hit ctrl-space, and then scroll down to DISTINCT and hit TAB I end up with:

SELECT 
	*,
	COUNT(DROP INDEX <cursor>
FROM msdb.dbo.backupfile

when I should end up with:

SELECT 
	*,
	COUNT(DISTINCT<cursor>
FROM msdb.dbo.backupfile

I don't understand why it is inserting the snippet even though I scrolled down and selected a different suggestion.

Anu D

Thank you for your post regarding SQL Prompt.

Can you kindly check if SQL Server 2008 intellisense is switched off as SQL Prompt and SSMS native intellisense don't go along?

You can turn off SQL Server 2008 intellisense using the following settings:

Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is Intellisense disabled here?

Also if you click General under the Transact-SQL list is Auto list members and Parameter information not selected?

Kindly restart management studio after saving this settings and recheck it and try reproducing the issue?

Kindly let me know if this fixes the issue.

MikeyC

Nope, I can't do that as I am using SSMS 2005, so there is no Intellisense to turn off.

MikeyC

Have you had a chance to try to replicate this yet?

Anu D

Apologies for the delay in replying you.

I was able to replicate the issue and hence logged in as a bug in our internal tracking system whose tracking id is SP-3405

Workaround for this issue is to select the word 'DISTINCT' from the suggestion box and double click to select it.

Kindly let me know if this helps.

Anu D

Also you can use 'Enter' to insert the DISTINCT instead of DROP INDEX.

MikeyC

Anu Deshpande wrote:

Also you can use 'Enter' to insert the DISTINCT instead of DROP INDEX.

That would work if I used Enter as a completion key, which I don't. The double clicking does work though.