Reorg index error - please help

• Pablo Campanini

  Say Hey Kid

  Points: 672

  More actions

  June 4, 2007 at 10:39 am

  #120344

  Hi all:

  I set up to run reorg on SQL Server 2005 on several tables in a database, but it always gives the same error:

  "Failed-1073548784) Executing the query "ALTER INDEX [IX_NOTES_03] ON [dte].[NOTES]

   REORGANIZE WITH ( LOB_COMPACTION = ON )

  " failed with the following error: "The index "IX_NOTES_03" (partition 1)

  on table "NOTES" 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."

  The index parameters does not specify anything about level locking. It says:

  "CREATE NONCLUSTERED INDEX [IX_NOTES_03] ON [dte].[NOTES][NotedInSystem] ASC)INCLUDE ( [WorkflowID],[TrackingNo]) WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [FG6]"

  My reorg job is not running anymore, please help

  Thanks

   

• jezemine

  SSCrazy Eights

  Points: 8109

  More actions

  June 5, 2007 at 1:12 am

  #710797

  see this thread:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=301624

  ---------------------------------------
  elsasoft.org