That's exactly what I'm planning to do.

I'll pickup a last weeks full backup, restore it on the test serv and try to run a script.

Thx

Wow, looks great! Comments are very usefull as well!

I'll tweak it a bit today and will try tomorrow.

Thanks once more!

@timeLimit = NULL

I didn't define any exclusions.

Can you please post your version of code?

Thanks

I have one index with >100k pages and 98% of avg fragmentation.

Hi,

THanks for your fast reply first!

I know, I'm using enabled EXECUTE dbo.dba_indexDefrag_sp @executeSQL = 1 statement in a script.

I'm sure I'm doing something wrong, but can't find what exactly....

Hi Guys,

I've some problem with running script. I've created a separate DB for the script tables "UtilityDB".

When I run a script it's back to me with "Procedure dba_indexDefrag_sp dropped" and...