Hi

Recently migrated to sql server 2005 from 2000. Also have SQL Server 2005 Standard edition. tried to rebuild indexes. but failed sevaral times due to following reason.

Message
Executed as user: MASGRP\strint. ...sion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:30:00 AM  Progress: 2008-04-07 02:30:13.92     Source: {2BA80A37-7FCB-47D7-9DB0-9E521EBB0324}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  Progress: 2008-04-07 02:42:10.53     Source: Rebuild Index      Executing query "USE [strsysnew]  ".: 0% complete  End Progress  Error: 2008-04-07 02:42:16.24     Code: 0xC002F210     Source: Rebuild Index Execute SQL Task     Description: Executing the query "ALTER INDEX [IdxSalvage] ON [dbo].[DELETE_MstGENLDept_xxx] REBUILD WITH ( PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = 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 package execution fa...  The step failed.

Here the table "DELETE_MstGENLDept_xxx" is flaged to remove from the database. Problem seams to be there ? is it ?

Also what is the meaning of "Online index operations can only be performed in Enterprise edition of SQL Server." ? is this due to standard edition ?

 Thanks

wimal

Hi,

Yes, the REBUILD option does not work with the ONLINE option set to ON in editions other than Enterprise and Developer. You would have to perform the REBUILDing with the option ONLINE = OFF. There is an option in the Rebuild Index task named, Keep index online while reindexing, which should be unchecked.

Regards...

Gogula G. Aryalingam (MVP - SQL Server)