Is it possible to acces 2 sql servers at the same time?

I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK
I've done this using linked servers. Never done it between 7 and 2000 but
it should work. Your query would look something like this.
Select a.col1, b.col1
from server7.db1.dbo.tablea a join server2000.db2.dbo.tableb b
on a.id=b.id
Here server7 and server2000 are your link server defined for you two
different servers.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
>
> I was wondering if it is possible to access 2 different
> databases on 2 different sql servers (7 and 2000) located
> in to different locations?
> Thanks
> CK
|||Sure. See if this helps: http://vyaskn.tripod.com/programming_faq.htm#q14
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"CK" <anonymous@.discussions.microsoft.com> wrote in message
news:94a601c485fd$49c0d1d0$a601280a@.phx.gbl...
I was wondering if it is possible to access 2 different
databases on 2 different sql servers (7 and 2000) located
in to different locations?
Thanks
CK