Linking 2000 SQL server to SQL 2005

Hi
Wonder if anyone can answer a couple of 'simple' questions for me
please.
I know that it is possible to link a SQL 2000 Server to a SQL 2005
server. What I need to know is is it possible to create a query across
both servers (if that makes sense). In other words, I have
transactional data from a number of different branch locations stored
in SQL 2005 but I have the actual branch details stored in SQL 2000.
What I therefore need to do is relate the transactional (2005) table
to the Branch table (2000) as I need to obtain the Branch Name from
the Branches table stored in SQL 2000.
I appreciate that I can migrate the SQL 2000 Branches table to SQL
2005 but we are not yet at the stage of mastering how to do this
(Integration Services I believe).
The other question is that instead of linking the servers, I can
register (in Management Studio) the SQL 2000 Server and can see the
2000 tables. How do I then create a query that uses both the SQL 2005
and SQL 2000 tables to achieve the same aim as above.
In Enterprise Manager (2000), I could just use the query editor GUI
and drag and drop database tables from various SQL 2000 databases into
the same query. Using the Management Studio query GUI, it only lets
you add database tables from the database that you are currently
querying.
Sorry for the lengthy post - any assistance would be greatly
appreciated.
Many thanks for your time.
Nobby
> What I therefore need to do is relate the transactional (2005) table
> to the Branch table (2000) as I need to obtain the Branch Name from
> the Branches table stored in SQL 2000.
Yes , just call select * from sqlserver2000.dbname.dbo.Branch on sql server
2005 machine

> In Enterprise Manager (2000), I could just use the query editor GUI
> and drag and drop database tables from various SQL 2000 databases into
> the same query. Using the Management Studio query GUI, it only lets
> you add database tables from the database that you are currently
> querying.
I have not playede with what you described , I prefer running/building
queries in Query Builder window and not using GUI
"Nobby" <shaneclark@.dsl.pipex.com> wrote in message
news:1186557088.925152.28570@.22g2000hsm.googlegrou ps.com...
> Hi
> Wonder if anyone can answer a couple of 'simple' questions for me
> please.
> I know that it is possible to link a SQL 2000 Server to a SQL 2005
> server. What I need to know is is it possible to create a query across
> both servers (if that makes sense). In other words, I have
> transactional data from a number of different branch locations stored
> in SQL 2005 but I have the actual branch details stored in SQL 2000.
> What I therefore need to do is relate the transactional (2005) table
> to the Branch table (2000) as I need to obtain the Branch Name from
> the Branches table stored in SQL 2000.
> I appreciate that I can migrate the SQL 2000 Branches table to SQL
> 2005 but we are not yet at the stage of mastering how to do this
> (Integration Services I believe).
> The other question is that instead of linking the servers, I can
> register (in Management Studio) the SQL 2000 Server and can see the
> 2000 tables. How do I then create a query that uses both the SQL 2005
> and SQL 2000 tables to achieve the same aim as above.
> In Enterprise Manager (2000), I could just use the query editor GUI
> and drag and drop database tables from various SQL 2000 databases into
> the same query. Using the Management Studio query GUI, it only lets
> you add database tables from the database that you are currently
> querying.
> Sorry for the lengthy post - any assistance would be greatly
> appreciated.
> Many thanks for your time.
>