Programmatically find MS Shipped Databases

Hello, Have you ever needed to programmatically find what databases in you server are part of Microsoft products? Maybe to use that information in your own piece of code? In my case, I needed that information to exclude Sharepoint and Biztalk databases from the AdaptiveIndexDefrag cycles that are part of the maintenance operations we deploy…


New Update of the SQL Server Management Pack (supports SQL Server 2000/2005 and now 2008)

A new version of the SQL Server Management Pack is available for download:   http://www.microsoft.com/downloads/details.aspx?familyid=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en (read carefully the System Requirements Section)   Release History:   3/23/2007 – Initial Release, version 6.0.5000.0 12/21/2007 – updated version 6.0.6247.5 3/31/2008 – Updated version 6.0.6278.8 10/29/2008 – Released version 6.0.6441.0, which introduced SQL Server 2008 support in addition to other…