Check for OpenRowSet in BOL.
>Is it possible to do a SELECT statement that uses tables on different servers? If so what is the syntax?
>
>Lets say we have -
> table1 - tblX resides on server - svrX userid = sa password = 1
>and
> table2 - tblY resides on server - svrY userid = admin password = 2
>
>thanks for the help.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com