I have a server table all of my servers listed overt there, I would like to
retrive server name from that table connect to the server querry about the
database sizes
and put in to the historical table. How i can loop through each server to
get the information dynamically. Basically i want to change my connections
dynamically.
--

Hello Srikanth,

Have a look at this

http://www.sqldts.com/default.aspx?298


This article shows you how to get a rowset into a variable which in your
case will be servers and how to loop over them. You can then change the
connection properties of the SQL Server connection using the results and
perform whatever action you want from there.

Allan

[quoted text, click to view]