Hello Toby,

Thanks for your reply. Would you be interested in sharing this code/application with others on this site? Maybe you could write and article? I for one would be interested to see it working. Can your tool be scheduled to, for example, to collect data every hour? My link connections are pulling data throught the day and night with no overhead to the SQL server or its users. I understand that there are many way to do the same thing, my code is just one of them. I'm not proclaiming that's the best but so far it works for my needs.

This is the kind of feed back I enjoy. To see what other are doing to make there job easier. We DBAs have lots on our plates including review and learning new versions of SQL server. I just hope that others DBAs will find ways to make there day a bit easier and share them with us here. Making SQL server work for the business is number 1 on the list but making it work for DBA should be number 2.

Thanks,

Rudy