• Thanks all for the comments and suggestions. You all are correct that i should have mentioned the version of SQL Server in the question. I agree with you all that PowerShell is not available in SQL Server 2005. I was working in SQL Server 2008, and i thought to ask this question since there are many new features and wanted to share and learn from you all. I will try to be more specific in future QotD.

    Once again thank you all.