SQL Query Help..!
- Thread starter Matt-Page
- Start date
![[TW]Fox](/data/man-of-honor/2009.png){kind=avatar}
For me, with that few servers to deal with, I'd probably go with writing some dynamic SQL via isql.exe in an Excel sheet.
http://msdn.microsoft.com/en-us/library/aa214007(v=sql.80).aspx
Then use the excel sheet to concatenate the names of the servers in your isql command line. Pipe the results to a text file, dump that in excel and add up the single column of figures.
http://msdn.microsoft.com/en-us/library/aa214007(v=sql.80).aspx
Then use the excel sheet to concatenate the names of the servers in your isql command line. Pipe the results to a text file, dump that in excel and add up the single column of figures.
That is somewhat like asking 'how long is a piece of string'. Exactly how you would do it depends on what tools you have access to, how the network to connect to the remote servers is configured, what programming languages you are familiar with and how you want to treat the data once you have it.
Essentially, you are looking to create the basics of a rapid update data warehouse, and that's quite a complex thing.
The alternative, managing the 160 connections via VBA in Excel is going to be horrendously slow and error prone. Not impossible, but also not pleasant.
You can create a link in your local DB to each remote DB using sp_addlinkedserver. You can then query each remote DB using something like:
Code:
select *
from linkname1.table1, linkname2.table1
where ...