Linked server sql 2000 to sql 2000

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)

Linked server sql 2000 to sql 2000

Author

Topic

rohans
Posting Yak Master

194 Posts

Posted - 2004-08-12 : 10:51:16

I set up a linked server in SQL 2000 to connect to another SQL 2000 server. The connection works and I am seeing the tables in EM. When I try querying from Query Analyzer using the following query
SELECT * FROM [linked_name].DBname.tblname

The error is:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'linked_name.DBname.tblname'.

All help appreciated.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-12 : 11:05:00

SELECT * FROM [linked_name].DBname.dbo.tblname

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

rohans
Posting Yak Master

194 Posts

Posted - 2004-08-12 : 11:15:59

Thanks, that works. I hope u can solve my next problem at
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38535

All help appreciated.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources