One thing you'll learn (if you have not already) is that SQL Server 2005's Maintenance Plans (which are actually SSIS workflows executed by SQL Server Agent Service) do NOT provide useful error information. I had to set up a script for a customer but spent my (very) early morning tearing out all the hair on my ageing head.
See, I got this from SQL Server History: Failed:(0) Alter failed for Server 'servername'. If that rings a bell for you then congratulations. It did not for me.
Recent comments