Home Forums SQL Server 2005 Data Corruption How to put database in single user mode while dbcc CheckDB? RE: How to put database in single user mode while dbcc CheckDB?
ChiragNS
One Orange Chip
Points: 26137
More actions
October 9, 2007 at 12:24 am
#740247
hi
You can do this with SSMS. Right click on the db and select Properties. In the Options tab set the Restrict access to SINGLE_USER.
"Keep Trying"