Saving Maintenance Plan Failed (How to Resolve)

If you encounter the error message “Saving maintenance plan failed” when trying to save a maintenance plan you created using the the wizard in SQL Server 2005 Management Studio (SSMS), the first (obvious) thing you should try, is to check if the latest service pack is installed and if it is not then install it! … Read more…

SQL Server 2008 Service Pack 1

SQL Server 2008 Service Pack 1 was just released yesterday (April 7, 2009). Along with the fixes for known bugs, this Service Pack also adds some new functionality to SQL Server 2008 mainly from the DBA’s perspective. What’s new Microsoft has added new functionality to SQL Server with this service pack. The main new features … Read more…

SQL Server 2005 Service Packs

Last night I installed Microsoft BizTalk Server 2006 R2. Though, during the configuration process of BizTalk, I was prompt that SQL Server 2005 Service Packs were not detected. At that time I though to myself; how do I find if any, and which Service Pack is installed for SQL Server? By reading the Microsoft Help … Read more…