• Thanks for the code! I've been using a script created by Gregory A. Larsen which I have modified to better suite my needs.

    As for "buggy" code. Sometime we write scripts that work well in our own environments and it may not run properly in others. This is not the responsibility of this site to see if ALL the code provide works perfectly. It would take them too long and need more staff to verify everything.

    Here is my recommendation. Use the scripts and modify it to suite your environment. It's free so really you can't complain. As a good DBA, you should try to modify the code so that 1) you better understand it, 2) you make it personalized to your environment and 3) you can help by provide your code here for others to see.

    If you don't like the script you can also rate it here. You can even submit your own code/articles for others to see and criticize. It's not easy publishing anything as you will always find someone who hates it.

    Thanks to everyone who submits code, articles, and help as these things make this site the best in the SQL world!

    Just my 2 cents worth.

    Rudy

    Rudy