Solved

The multi-part identifier "myServer.crm.dbo.data.id" could not be bound.

Posted on 2008-10-12
3
604 Views
Last Modified: 2012-05-05
I get the following error when running a query between 2 linked servers.

The multi-part identifier "Server2.crm.dbo.data.id" could not be bound.



update data set valid = [Server2].[crm].[dbo].[data].[valid]
from  [Server2].[crm].[dbo].[data]
where data.ID =[Server2].[crm].[dbo].[data].[id]

Any ideas ?

thanks
0
Comment
Question by:JElster
  • 2
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 22698942
this should work better:
update data 
  set valid = r.[valid]
from  data 
join[Server2].[crm].[dbo].[data] r
 on  data.ID = r.[id]

Open in new window

0
 
LVL 1

Author Comment

by:JElster
ID: 22698978
Thanks.. but why doesn't my original work?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22698985
because it does not conform to the syntax requirements... that's all...
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Trigger selecting another database 4 37
SQL Server 2012 express 24 37
Isolation level in SQL server 3 49
Bubble user-defined Sql RAISERROR(...) to c# exception 14 166
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now