Hi All,

Are there any routines out there which Check Consistency of a Database & all of it's Tables and if ok then Reindexes the lot?

I already have a scheduled task which runs every night, I could build into that something extra which does this once a month or so. Only thing is it will run unattended, it won't be until the next morning that we check the logs to see how it got on.

Cheers,