First time reorg job failed - sql 2005

• Pablo Campanini

  Say Hey Kid

  Points: 672

  More actions

  January 28, 2007 at 4:54 pm

  #176675

  This is the error after i run a maintenance reorg job, it does not do anything

  Any parameter to set?. Please help

  Failed-1073548784) Executing the query "ALTER INDEX [IX_BWPHIST_04] ON [dte].[BWPHIST] REORGANIZE WITH ( LOB_COMPACTION = ON )

  " failed with the following error: "The index "IX_BWPHIST_04" (partition 1) on table "BWPHIST" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 28, 2007 at 10:13 pm

  #686073

  From BOL: An index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF.

  Issue the command with ALLOW_PAGE_LOCKS ON

   

   

  MohammedU
  Microsoft SQL Server MVP