Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to connect to another SQL server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00838803
Message ID:
00838815
Vues:
16
Hi!

You should link the servers. To do so, you go to the security folder of one of the Servers, then select linked servers and then add new linked server, for more information, you can read the books online.

Once you have the servers linked then you can query the linked server tables with fully quilified names

e.g.
select *
from   LinkedServer.Database.Owner.TableName
HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform