I spent years working with batch files, osql and server lists to retrieve info and execute code on multiple databases simultaneously.

Now I use Red-Gates Multi script. Its the most useful tool I have and its cheap. When you manage 300 SQL servers its essential.

I'm lookign forward to the new mutli-script feature in SQL2008 SSMS but dont think it'll be as good as Multi-Script.

My Idera SQL Admin toolkit also has this functionality but its not as good as Red Gate.

My 2c

cheers

Alan Cranfield