• That is serious overkill. It's extremely unlikely that you need to rebuild all indexes every time. Look up Ola Hallengren's index maintenance script (or go to http://ola.hallengren.com/) and use that.

    You don't need to run them manually. While Express doesn't have SQL Agent, the OS it's installed on has the Windows Scheduler.

    Your script will rebuild all indexes, no matter what, but your 'check' script checks index and column statistics and column statistics aren't updated as part of an index rebuild, hence won't show a changed updated date

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass