connecting on SQL server database to another SQL server database

I am hoping to find a reference for the procedure on
connecting one SQL server database (SQLServerA) with
another SQL server database (SQLServerB) where SQLServerA
is in a different physical location and on a different
network from SQLServerB. In the past SQLServerA was an
Access database that used 'linked tables' to bring the
tables in from SQLServerB. I am hoping to recreate the
linked tables functionality on the SQL server. I'd
appreciate any websites or manuals,
Thanks,
Rachel"Rachel Gibson" <gibsora@.shands.ufl.edu> wrote in message
news:822201c40776$eba263c0$a601280a@.phx.gbl...
> I am hoping to find a reference for the procedure on
> connecting one SQL server database (SQLServerA) with
> another SQL server database (SQLServerB) where SQLServerA
> is in a different physical location and on a different
> network from SQLServerB. In the past SQLServerA was an
> Access database that used 'linked tables' to bring the
> tables in from SQLServerB. I am hoping to recreate the
> linked tables functionality on the SQL server. I'd
> appreciate any websites or manuals,
You can use Linked Servers to accomplish that, see BOL for more
instructions. Basically you can use EM to create the link or
sp_addlinkedserver.
Steve