Excellent!
First time I see an easy to understand and very useful SQL DMO example.
Congratulations,
Geert
Very good concept, but unfortunately as always, I can never get VBA script to work :-(
When I have time, I may try to do the same thing using .NET, C# and Office Interop Libraries.
Alastair
Incredibly powerful! Thank you for the great example. Awesome stuff!
Kevin
Simple and elegant.
This one worked for me straigt from the 'box'.
Tom
Have you followed the instructions on the helptab of the worksheet? The config tab contains the following entries in column A, all of which need to be deleted (including List your SQL Server HERE) and replaced with the SQL Server names in you environment:
The VBA code loops through the list of server specified in on the config tab column A (Column A is a named Excel Range "Server").
DOH!
Thanks cmille19, should have actualy used my brain on this. Working like a charm now.
Editor's Note: : Dr. Omri Bahat works for SQLFarms, a software vendor of SQL Server tools.
