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.
View Complete Post