On the server1 create Linked Server to the server2. After that you can use four parts names for server2. See BOL for details.
>I'm trying to pass SQL 2K the following update command but an getting an invalid connection handle on the SQLEXEC() statement. I'm guessing that the problem is due to the update command referencing more than one server and database. How can I get around this error?
>
>UPDATE table1 set table1.field1=server2.database2.owner2.table2.field2 where
>table1.field1=server2.database2.owner2.table2.field2
>
>My SQLCONNECT is SQLCONNECT('DSN1').
>
>I tried adding a second SQLCONNECT statement using the DSN to connect to the second server and database but the SQLEXEC() statement only has a place to use one connection.
>
>LCannon...
--sb--