Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sinam
Starting Member
3 Posts |
 Posted - 2002-01-28 : 04:21:23
|
| Hi,My scenario is :I want to compare two fields of two tables in two databases which resides in two remote locations.eg: field1 of table1 in database1 on SQLSRV1 in USA and field1 of table1 in database1 on SQLSRV2 in GERMANY.Thanks & Regards in advance.Sinam |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-28 : 05:14:47
|
| create a linked server and use svrname.dbname.owner.tbl.field for the remote data.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Connecting to 2 sql servers and comparing 2 fileds