DBCC commands for making it in single user mode | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DBCC commands for making it in single user mode

Does DBCC commands make the db in single user mode.If yes then how can I bring back the state of db again to earlier state as it was before running dbcc commands.
I am wondering whether running dbcc commands will forcibly kill all the users
For few DBCC checks you must specify the single-user mode before running them and if the task of single-user is handled by a DBCC statment then it will bring back the database into multi=user mode without user intervention. DBCC statements will not force the users to drop out, you must take care of this instance manually in order to avoid any overlapping or performance issues, utmost during the execution of DBCCs the performance will be low and new connections may not be accepted. BTW any specified DBCCs you’re looking in this fashion? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>