• It was more to the point of trying to get the DBCC command to run...I hadn't researched it enough Gail, but your points are valid.

    As it turns out, there is no way to change the database state while other users are using the database, so the idea is definitely not going to work anyways.

    The reason I thought it odd to make a complete snapshot of the db to then run DBCC against is that my database is large, and the time it would take to do a daily snapshot to do this with, just seemed like an off approach to me.