• Joey,

    We face the same problem on Indexes. However I just need one simple job.

    Create and SP on one of you databases on your server and executed it using a job

    The content of this SP ==>

    exec sp_msforeachtable @command1="print'?' dbcc dbreindex ('?')"

    Yes....thats all

    Running this on a full operational 100 Gb OLTP database takes just 2 hours to compete.

    Regards,

    Guus Kramer

    The Netherlands