Peso (4/25/2008)

---

OP didn't state if the Fk was a constraint or not.

And since OP used a correlated subquery in his original post, I had to raise a flag for this...

Peso (4/25/2008)

---

To replace the functionality 100%, we should use LEFT JOIN.

The correlated subquery might return NULL if there is no match.

UPDATEmt

SETmt.FKID = x.FKID

FROMMyTable AS mt

LEFT JOINMyFK2Table AS x ON x.ID...

Well, I exited the previous query with 1.4 million rows left to do (instead of 8.4 million originally).

It took...

Many thanks! I went with GilaMonster's query and it's scary how fast it was.

I thought there may be some issue doing a join on 8 million rows of two wide...

Amazing! I really wasn't holding out much hope as the symptoms they had were somewhat different to mine, but the following line did it:

ALTER AUTHORIZATION ON DATABASE::[dbname] TO [sa];

Many thanks...