469,330 Members | 1,274 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

Syntax to access database on another server

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.
Feb 26 '08 #1
2 1882
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.

Feb 26 '08 #2
Thanks for your response.
Feb 29 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Jan van Veldhuizen | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
6 posts views Thread by iam247 | last post: by
9 posts views Thread by Wayne Smith | last post: by
10 posts views Thread by rcnews | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.