Microsoft recently addressed an issue in SQL Server 2005 Service Pack 2 (SP2) which may impact customers using cleanup tasks in Maintenance Plans and SQL Server Integration Services packages. The issue is described in detail here –http://support.microsoft.com/kb/933508. We have created a General Distribution Release (GDR) #50000939 to address this issue which is available for download and we have included the GDR in a refresh of the SP2 installation package.
This issue impacts customers who downloaded SP2 update before March 5th. Customers who download SP2 on or after Monday, March 5th, 2007 will not need take any further action since the refreshed SP2 installation package includes the necessary GDR.
Today, a refresh of the SP2 is available online. If you have not yet installed SP2, you should download the refresh as it includes all fixes for the maintenance issue. SQL Server 2005 Service Pack 2 refresh is available at: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
If your organization has downloaded and installed SQL Server 2005 Service Pack 2 (SP2) prior to March 5th, 2007 Microsoft recommends you apply the GDR either from Microsoft Update or by downloading it directly from http://go.microsoft.com/fwlink/?LinkId=85124. As described in the KB article, this issue is primarily if you use cleanup tasks in maintenance plans and SQL Server Integration Services packages.