Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To See One Server From Another Server ?
Message
De
21/06/2006 17:37:08
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
How To See One Server From Another Server ?
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01130630
Message ID:
01130630
Vues:
69
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform