Syntax to access database on another server
- From: compquest <vtestaccount@xxxxxxxxx>
- Date: Tue, 26 Feb 2008 09:20:01 -0800 (PST)
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.
.
- Follow-Ups:
- Re: Syntax to access database on another server
- From: Jack Vamvas
- Re: Syntax to access database on another server
- Prev by Date: [SQL query] Generate a report from events?
- Next by Date: Re: sql query which has got 3 dynamic parameters
- Previous by thread: [SQL query] Generate a report from events?
- Next by thread: Re: Syntax to access database on another server
- Index(es):