I just love this message! I never willingly use the built in maintenance wizards or maintenance plans, however the database backups are all through maintenance plans at my current site.
Today I had a failure of a backup job for no apparent reason, examination of the output showed the following message
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
A quick check showed that the problem arises if an index is created on a computed column. Right ??? is there a fix - well yes but only with service pack 4 and my server is running sp3 and as it's a production system I can't just apply a service pack. http://support.microsoft.com/?kbid=902388 for more details.