What are the challenges you face when working across database platforms? Take the survey
Options

SQL prompt suggestions conflict with SQL 2008 intellesence

Len.WrightLen.Wright Posts: 4 Bronze 1
edited April 1, 2010 6:16AM in SQL Prompt Previous Versions
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Len.WrightLen.Wright Posts: 4 Bronze 1
    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.
  • Options
    Anu DAnu D Posts: 876 Silver 3
    No problem.

    Let us know if you have any issues or questions regarding the product,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Len,

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

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.