How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!
You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegro ups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>