Syntax to access database on another server

[compquest]

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.

[Jack Vamvas]

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" <vt**********@gmail.comwrote in message
news:d3**********************************@d62g2000 hsf.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.

[compquest]

Thanks for your response.