Run Query on database on a different server

Must I have a linked server in order to pull data from another SQL server ?
Both servers are SQL2000 SP4 standard.
No if you use OPENDATASOURCE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_2be1.asp
Having the link server is more convenient is you will be pulling data on a
regular basis.
"WANNABE" wrote:

> Must I have a linked server in order to pull data from another SQL server ?
> Both servers are SQL2000 SP4 standard.
>
>
|||Thanks, that was what I was looking for...
What are some issues regarding Linked server, that need to be considered
before implementing Linked servers ?
================================================== ====
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA"
<EdgardoValdezMCTSMCITPMCSDMCDBA@.discussions.micro soft.com> wrote in message
news:4E58387B-10BF-42D5-8C61-55EC4E3C1D70@.microsoft.com...[vbcol=seagreen]
> No if you use OPENDATASOURCE
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_2be1.asp
> Having the link server is more convenient is you will be pulling data on a
> regular basis.
>
> "WANNABE" wrote:
|||Implementing linked servers is very straightforward. There are some gotchas,
like collation compatibility, etc. but, as long as the connectivity is there,
it offers an easy way to access data from one server to another
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx
http://msdn2.microsoft.com/en-us/library/ms188279.aspx
"WANNABE" wrote:

> Thanks, that was what I was looking for...
> What are some issues regarding Linked server, that need to be considered
> before implementing Linked servers ?
> ================================================== ====
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA"
> <EdgardoValdezMCTSMCITPMCSDMCDBA@.discussions.micro soft.com> wrote in message
> news:4E58387B-10BF-42D5-8C61-55EC4E3C1D70@.microsoft.com...
>
>