Syntax to access database on another server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

compquest - 26 Feb 2008 17:20 GMT

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.

Reply to this Message

Jack Vamvas - 26 Feb 2008 20:44 GMT

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

Signature

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.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.

Reply to this Message

compquest - 29 Feb 2008 20:36 GMT

Thanks for your response.

Reply to this Message