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.

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?

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?

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

alter index IX_Foo on tbl_bar

set (ALLOW_PAGE_LOCKS =on)

This is an old problem, but I just experieced it now. I noticed that if you are running the Standard edition of SQL 2005 (meaning not Enterprise edition) you can't rebuild indexes online.

So setting this option ONLINE = OFF may solve your problems.