SQL prompt suggestions conflict with SQL 2008 intellesence

Len.Wright

Hi,

Just upgraded our servers from 2005 to 2008 and now my SQL prompt 4 autocomplete suggestions are running at the same time as the SQL 2008 Intellesence, so I get a collision of both features, and must manually correct the suggested strings.

How do I fix this?

thanks
Len

Anu D

Thank you for your post regarding SQL Prompt.

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.

Anu D

Did the above suggestion fixed the issue?

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.

Len.Wright

Hi ,
thanks for your asistance. I don't really want to turn off Intellisence, but I would like to keep most of the features of SQL Prompt. I'll experiment a little and see if I can find a combination that makes sense to me.

Anu D

No problem.

Let us know if you have any issues or questions regarding the product,I'll like to help.

David Atkinson

Len,

Which features of SSMS2008 Intellisense would you like to preserve alongside your SQL Prompt use?

David Atkinson
Product Manager
Red Gate Software