The multi-part identifier could not be bound

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

The multi-part identifier could not be bound

Postby soatley » Sat Sep 04, 2010 2:00 pm

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.
soatley
 
Posts: 7
Joined: Wed Jun 03, 2009 4:14 pm

Postby Anu Deshpande » Tue Sep 07, 2010 10:42 am

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: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby soatley » Wed Sep 08, 2010 1:44 pm

Thanks, that did fix the issue! I just turned off the Intellisense from SSMS 2008 and the problems went away.

Shawn
soatley
 
Posts: 7
Joined: Wed Jun 03, 2009 4:14 pm

Postby Anu Deshpande » Wed Sep 08, 2010 1:45 pm

Many thanks for your confirmation.

We are pleased that your issue is resolved :)
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests