Click here to Skip to main content
15,881,600 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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....
Posted
Updated 26-Dec-11 1:14am
v2

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[^]
 
Share this answer
 
Connect to each server and run this query on that server:
SQL
SELECT name
FROM master..sysdatabases


If you want to make sure that it has all the required tables run this query after that
SQL
use DataBaseName
Select Table_name 
From INFORMATION_SCHEMA.TABLES


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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900