Rebuild index failed

renching

I scheduled a maint plan to rebuild index. All table's indexes are successfully built except for one table. The error message I got:

Failed:(-1073548784) Executing the query "ALTER INDEX [Index_name] ON [dbo].[table] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = ON )
" failed with the following error: "Online index operations can only be performed in Enterprise edition of SQL Server.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Can someone tell me what the problem is and how to fix it Thanks.

Derek Comingore


I am assuming you are using the Enterprise Edition of SQL 2005

renching

We are using Enterprise Edition. All other tables can be reindexed. This is the only table has problem. And this is not a big table. The indexed column is nvarchar(50).

Any ideas

Gabby_Girl_Lynne

Your post was over a year ago but I'm now experiencing the same problem. It's working on over 300 tables but not this one in particular.

Executing the query "ALTER INDEX [GEM_DBKEY_IDX] ON [dbo].[JOBS] REORGANIZE WITH ( LOB_COMPACTION = ON )
" failed with the following error: "The index "GEM_DBKEY_IDX" (partition 1)
on table "JOBS" 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.

error -1073548784

Can you share what you did to get past it

widdowsj

I also had this problem recently. The answer is fairly simple:

alter index IX_Foo on tbl_bar

set (ALLOW_PAGE_LOCKS = on)

For some reason when the guy who sits next to me creates an index it defaults to page locks off - not sure why