Hello, I have SQL Server 2005 SP2 64 bit (because of one application) and I'm not able to run maintenance job successfully. Always get same error message: 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:47:41 AM Progress: 2011-03-13 11:47:45.22 Source: {42716F87-0D2B-48A5-B447-4E815803D2A5} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:47:41 AM Finished: 11:47:46 AM Elapsed: 5.538 seconds. The package execution failed. The step failed. I tried to use view T-SQL function, ran the script manually and it worked perfectly but as a part of maintenance job didn't. I tried to delete the plan and create it again, same error appeared as above. Can someone please give me advice how to fix this? Thanks and regards, Radek

Hello, I was able to run the Maintenance job with success I've just had to change one option on SQL Server. EXEC sp_configure 'allow updates', '0'; RECONFIGURE WITH OVERRIDE After the Check DB integration could be turned on with the same command. EXEC sp_configure 'allow updates', '1'; RECONFIGURE WITH OVERRIDE Radek