Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql 2000 link to sql 2008

Author  Topic 

troyerox
Starting Member

2 Posts

Posted - 2009-07-28 : 07:58:26
We have upgrade one server to SQL 2008 and we still have other databases on a SQL 2000 server. I am able to register the SQL 2000 server on the SQL 2008 box and can run queries from the SQL 2008 instance which distributes to the SQl 2000 databases but I cannot run queries from the SQL 2000 instance which distributes to the sql 2008 database. We have a lot of sp's on the sql2000 box that need to now include the database on the sql2008 box and need to run from the 2000 box.
   

- Advertisement -