question

If you run DBCC CHECKDB without any other arguments, you will not have locking issues, as DBCC CHECKDB uses a snapshot to examine the database. If you repair your database with DBCC CHECKDB there will be some locking going on and users might experience problems. On the other hand - if you have errors in your database, you might want to thrown out your users from the database anyway. Read more about DBCC CHECKDB in Books Online: [ http://msdn.microsoft.com/en-us/library/ms176064.aspx][1] [1]: http://msdn.microsoft.com/en-us/library/ms176064.aspx