[/quote]

Because it is easy to automate using PowerShell. Kendal has put in a lot of efforts and the script that he does a lot of better checks than u have. So its better not to reinvent the wheel.[/quote]

Hey, all power to PowerShell developers! If there is a better script then please use it. I and others that have tested and used this script have found it to work very will and fits their needs. I didn't write the script to compete, just to provide a way to get useful information from within SQL Sever itself.

I personally don't spend time in PowerShell as I would rather spend my time learning more on performance tuning/enhancements, high availability and disaster recovery.

Thanks for your comments 🙂

Rudy