If I didn't define the transaction, the rollback will not work, right?

Do you have any suggestions for me to overcome this issue?

Can you provide more detail information?

I want to select any indexes which are higher than 5% for reorgs later

This is the error message

Exception calling "Fill" with "1" argument(s): "The SelectCommand property has not been initialized before calling 'Fill'."

Thanks for your wonderful suggestions, I will do that! One more question, I have done some researches about table rebuild, but I found nothing useful. Does SQL Server has table...

so do I need to do table reorg? when do I need to table reorg?

Thanks a lot and it works very good.

So I changed the store procedure like this, but it didn't bring me any outputs in the table at all.

CREATE PROCEDURE procedure1

AS

DECLARE cursor_1 CURSOR FOR

SELECT

'This is a executable...

The table should have two columns, one is for the executable query and the status. Should looks like this

Query ...

I changed the query like this, but then the query just keeping execute the outcomes and marked as all 'C', even it passed the specific time.