>OPEN @lorsData > WHILE 0 = 0 BEGIN > FETCH NEXT FROM @lorsData INTO @lcTABNAME, @lcNAME, @lfDFG > IF @@FETCH_STATUS <> 0 BREAK > > BEGIN TRY > EXEC('ALTER INDEX ['+@lcNAME+'] ON ['+@lcTABNAME+'] REBUILD ') > PRINT CAST(@lfDFG AS VARCHAR(30))+' ALTER INDEX ['+@lcNAME+'] ON ['+@lcTABNAME+'] REBUILD /*WITH(ONLINE = ON)*/' > END TRY > BEGIN CATCH > PRINT 'FAILED: '+@lcTABNAME+' '+@lcNAME > END CATCH > > END > CLOSE @lorsData > DEALLOCATE @lorsData >>