Optimization Job

• Bidec

  SSCommitted

  Points: 1666

  More actions

  May 19, 2003 at 11:08 am

  #64675

  When the optimization job runs against my database I get the fllowing error:

  [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'.

  When I ran a trace, I got this :

  dbcc dbreindex(N'[dbo].[Tablename]', N'', 90, sorted_data_reorg)

  Any idea what could be causing this ?

  Thanks.

• barwickl

  SSC Veteran

  Points: 298

  More actions

  May 19, 2003 at 11:40 am

  #457675

  I'm also having this problem. (See my slightly earlier post "Maintenance plan/DBCC problem").

  It might be worth having a look at a MS knowledgebase article:

  http://support.microsoft.com/?kbid=301292

  Although this hasn't helped me! Anyone got any other ideas?

  Thanks

• barwickl

  SSC Veteran

  Points: 298

  More actions

  May 19, 2003 at 11:51 am

  #457676

  The following link discusses the problem:

  http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20293276.html

  I believe it is a known problem in sqlmaint.exe which effects databases with computed columns??

  Does anyone know of an MS tracking number for this problem?

• Le Rhun Philippe

  Say Hey Kid

  Points: 674

  More actions

  May 4, 2004 at 10:06 am

  #505158

  Hi, I have this problem on my job. So, go on this URL

  http://support.microsoft.com/?kbid=301292

  And then, add to your job (before your shrink) :

  SET ARITHABORT ON

  SET QUOTED_IDENTIFIER ON

  SET CONCAT_NULL_YIELDS_NULL ON

  SET ANSI_NULLS ON

  SET ANSI_PADDING ON

  SET ANSI_WARNINGS ON

  SET NUMERIC_ROUNDABORT OFF

  Philippe