Syntax to access database on another server

#1 (**permalink**) 03-01-2008, 02:49 PM

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.

#2 (**permalink**) 03-01-2008, 02:49 PM

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.

#3 (**permalink**) 03-01-2008, 02:49 PM

Thanks for your response.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode