August 2006 - Posts

sysmaint.exe failed

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.  for more details.



Posted by GrumpyOldDBA with no comments
Filed under: