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 17:37:08
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
How To See One Server From Another Server ?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01130630
Message ID:
01130630
Views:
68
From SQL Server Group named SOL-BOS02\SQL_A, I want to access to table located in SOL-BOS02\SQL_B. Then I have proceeded like this...

--> Here I am in SQL_A server <--
select * from [SOL-BOS02\SQL_B]..MyDatabase.MyTable

But I got the following error message:
"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."

Does I need to add the 2nd server info into table sysservers to see it?
Or there exists another way to include another server into my Select SQL?

By the way, it it possible to create a view on a linked server? Because, when I attempt to create a view, in the list of available tables, I cannot see others than local tables.

Thank you in advance!
Marc
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Next
Reply
Map
View

Click here to load this message in the networking platform