|
Home > Archive > SQL server exams > February 2003 > Retrieving data from a db on another SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Retrieving data from a db on another SQL Server
|
|
| sjgross 2003-02-11, 12:43 pm |
| Hi all,
If I want to retrieve data from a database that is on a different sql server from the one where I am executing the query, do I have to use a linked server? Is there another way to do this?
Thanks! | |
| glenndba 2003-02-12, 1:27 pm |
| OPENROWSET or OPENDATASOURCE | |
| naresh_sky 2003-02-13, 5:15 am |
| hi sjgross.
i agree with glenndba..
it should be a linked server if u r frequently giving the query on the remote
server.
Cheer's
naresh |
|
|
|
|