If you are considering combining 2 tables , use Linked Servers . Basically ,
you would register another server , as a Linked Server
then simply reference the tables accordingly

--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com




"compquest" <vtestaccount@gmail.com> wrote in message
news:d3c84685-ec72-439e-99fa-8fdf1c29e728@d62g2000hsf.googlegroups.com...
>I know how to access different tables on the same server by prefixing
> the table with the database name. Is there anyway to prefix the
> server name to link two tables across servers? Thanks.