By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,716 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,716 IT Pros & Developers. It's quick & easy.

Syntax to access database on another server

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Thanks for your response.
Feb 29 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.