T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view

You may also like...

2 Responses

  1. It’s not a great workaround though if you split out your DBCC CHECKDB into the separate checks to deal with very large databases and time constraints (CHECKALLOC, CHECKCATALOG, etc).

    If you do that, based on Arun’s blog post here (https://blobeater.blog/2017/01/03/checking-dbcc-checkdb/) then that DBCC INFO value doesn’t get updated.

    So I would say that it’s not even a complete workaround and I’ve voted 🙂

    • Aaron Nelson says:

      Shane,
      Thanks for the comment. You make a really great point and I didn’t realize that the solution wouldn’t work for everyone. I will update the post with that!

Leave a Reply

%d bloggers like this: