Solved

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

Posted on 2008-10-12
3
600 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

706 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

17 Experts available now in Live!

Get 1:1 Help Now