Hi,

I am moving away from maintenance plans, and have custom jobs now to do my backups and re-indexing.

Last thing left on the list is "integrity" tab on the maintenance plan. What T-SQL can I use to perform the same function? It seems to be a DBCC CHECKDB? If so, does anybody use the repair part of the command? I see the database must be in single user for the repair to work - not practical on my production server. Seems to me DBCC CHECKDB is only used as informational to gather info of each DB.. and errors are for me to follow up on?

Thanks !
Hugh


MS Sql Server LazyDBA home page