The multi-part identifier could not be bound

soatleysoatley Posts: 9
edited September 8, 2010 8:45AM in SQL Prompt Previous Versions
I am running into an issue on a machine with SQL Prompt 4.

When I Format SQL, it underlines every column and table name in red and when hovering over each item it says 'The multi-part identifier [column/object name here] could not be bound.'

Everything runs fine when executed, it just displays with all the red underlines. SQL Prompt reformats the layout without an issue and all the table/column name prompts work too.

It doesn't matter what database or what SQL script I'm editing at the time.

I am running Windows 7 Pro and using the SQL Server 2008 Management Studio Tools. My SQL Prompt version is 4.0.3.12.

Comments

  • Many thanks for your post.

    I suspect it is SQL Server 2008 underlines the error and not SQL prompt.

    Can you kindly check if SQL Server 2008 intellisense is switched off?

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

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

    You can see a sub-setting 'Underline error' that's the option which is causing the issue for you.

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

    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: [email protected]
  • Thanks, that did fix the issue! I just turned off the Intellisense from SSMS 2008 and the problems went away.

    Shawn
  • Many thanks for your confirmation.

    We are pleased that your issue is resolved :)
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.