Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To See One Server From Another Server ?
Message
From
21/06/2006 19:08:48
 
 
To
21/06/2006 17:37:08
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01130630
Message ID:
01130653
Views:
14
>select * from [SOL-BOS02\SQL_B]..MyDatabase.MyTable

Make sure you use the full four-part naming for objects in external servers:
Server.Database.Schema.Object
Example: OtherServer.TestDB.dbo.TestTable

>"Server: Msg 7202, Level 11, State 2, Line 1
>Could not find server 'SOL-BOS02\SQL_B' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."

Did you successfully run sp_addlinkedserver? You have to do this -- or the management GUI equivalent -- before you can use a linked server.

One way to create a view with a linked server is with T-SQL code like this:

CREATE VIEW TestLinkedServer AS SELECT * FROM OtherServer.TestDB.dbo.TestTable

Chris
Christopher Bohling, Consultant
http://www.ChristopherBohling.com
Previous
Reply
Map
View

Click here to load this message in the networking platform