SELECT C.NumCol1, O.NumCol1, C.StrCol2, O.StrCol2, ...
FROM MyLiveDatabase.dbo.MyTable as C -- "Current"
     JOIN MyRestoredDatabase.dbo.MyTable AS O -- "Old/Original"
          ON O.PKey = C.PKey
WHERE    (C.NumCol1 <> O.NumCol1 
             OR (C.NumCol1 IS NULL AND O.NumCol1 IS NOT NULL)
             OR (C.NumCol1 IS NOT NULL AND O.NumCol1 IS NULL))
      OR (C.StrCol2 <> O.StrCol2 COLLATE Latin1_General_BIN2 
             OR DATALENGTH(C.StrCol2) <> DATALENGTH(O.StrCol2)
             OR (C.StrCol2 IS NULL AND O.StrCol2 IS NOT NULL)
             OR (C.StrCol2 IS NOT NULL AND O.StrCol2 IS NULL))

FROM MyLiveServer.MyLiveDatabase.dbo.MyTable as C -- "Current"
     JOIN MyOtherServer.MyRestoredDatabase.dbo.MyTable AS O -- "Old/Original"
 

quote:

---

Originally posted by Kristen

Although: If you database is backed up direct to tape, using a "SQL Agent" of some sort to directly extract the database from the disk, then it might be complicated restoring it to a differently named database. Let's hope that is NOT the case! This job is much MUCH easier if you backup to a File on the server, and THEN backup the File TO TAPE

If you need to restore the database to a different machine you could then use four part naming

FROM MyLiveServer.MyLiveDatabase.dbo.MyTable as C -- "Current"
     JOIN MyOtherServer.MyRestoredDatabase.dbo.MyTable AS O -- "Old/Original"
 

---