Yes,the goal is to collect information from 100+ servers in a domain.

I will have a sql script which will exist/run on one source server.

It will take the server names from one table ..connect to that server...extract the required data(simple select statement) from that server and dump it into a table on the source server(ideally on the same server where the script is being executed).

Likewise it will loop through the entire table(server names) till it ends and gathers the data from all servers and store it on the source server.

I have an SSIS package built doing this.I would like to get a sample t-sql script with the required details.

An outline to get an idea is good enough.

No cursors please.

Thanks