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/d...br />
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@.discussi
ons.microsoft.com> wrote in message
news:4E58387B-10BF-42D5-8C61-55EC4E3C1D70@.microsoft.com...[vbcol=seagreen]
> No if you use OPENDATASOURCE
> http://msdn.microsoft.com/library/d... />
z_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/pr...s/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@.discussi
ons.microsoft.com> wrote in messa
ge
> news:4E58387B-10BF-42D5-8C61-55EC4E3C1D70@.microsoft.com...
>
>