在局域网中查找SQL表 [英] Find SQL Table in LAN

问题描述

假设我在局域网中有五个M/c，即Node-1，Node-2，Node-3，Node-4，Node-5.
在两个m/c中分别有两个节点分别是Node-1，Node-2和一个MSSQLSERVER实例，其中一个存在于Database(``Student'')和相关表(即Node-2)中.
我想这样做，如何通过LAN内的VB.net编码从Node-2 m/c中现有数据库的Node-4 m/c中查找呢? >
请帮助我....

Suppose I have Five M/c in LAN, i.e. Node-1, Node-2, Node-3, Node-4, Node-5.
There are MSSQLSERVER instance in two m/c respectively Node-1, Node-2 and one in there have been in Database(''Student'') & related tables(i.e. Node-2).
I want to do that, how will i do to find from Node-4 m/c of existing database(''Student'') in Node-2 m/c through VB.net coding within LAN????

Please help me....

推荐答案

您的问题不是很清楚，但是如果您要表达的是如何从驻留在不同位置的多个SQL Server数据库中获取数据， SQL Server实例，请查看链接的服务器 [

Your question wasn''t very clear but if you mean how you can fetch data from multiple SQL Server databases which reside on different SQL Server instances, have a look at Linked Servers[^]

连接到每个服务器并在该服务器上运行此查询:

Connect to each server and run this query on that server:

SELECT name
FROM master..sysdatabases

如果要确保它具有所有必需的表，请在该查询之后运行

If you want to make sure that it has all the required tables run this query after that

use DataBaseName
Select Table_name 
From INFORMATION_SCHEMA.TABLES

而且，如果您不知道如何枚举所有可用的SQL Server:
http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx [ ^ ]

希望对您有所帮助.

And if you don''t know how to enumerate all available SQL Servers :
http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx[^]

Hope it helps.

这篇关于在局域网中查找SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！