Also, give this code a try in a test environment.

update dbo.xTest set

location = xu.location

from

dbo.xTest xt

inner join dbo.xUpdate xu

...

Could you please post the DDL (CREATE TABLE statements) for the two tables? Also, how are the tables related?

I see two choices, neither of which I would implement without involving the vendor of the product, unless you own it.

One requires upgrading to SQL Server 2005/2008 and changing the...

The query Gail had you run returns the version of SQL Server you are connected to, not the version of the client tool running the query.

Luke L (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under...

I think that is fallback option if the EU decides Oracle and Sun shouldn't merge. 😉

You probably have the SQL Server 2005 client tools installed on your desktop. SSMS can work with SQL Server 2000.

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE....

GilaMonster (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

GilaMonster (1/19/2010)

---

Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page...

Sounds good.

You can do it for free, do it yourself instread of relying on...

My concern is the drive being powered off possibly causing data corruption.

GilaMonster (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No...

You have verbalized the desired output, could you show us what the final result of the query would look like? A picture is like a thousand words. Seeing...

Paul White (1/19/2010)

---

Alvin Ramard (1/19/2010)

---

Not a fast...