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 coding within LAN????

Please help me....
Updated 26-Dec-11 1:14am

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:
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 

And if you don't know how to enumerate all available SQL Servers :[^]

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