10
Database '%S_DBID' is not in single user mode - may find spurious allocation problems due to transactions in progress.
This warning occurs when you execute dbcc checkalloc on a database that is not in single-user mode. dbcc checkalloc displays this message and then continues to execute.
Executing dbcc checkalloc on a database that is not in single-user mode may cause error messages to display that do not reflect the actual state of your database. These error messages are referred to as spurious (or false). Error messages 2521, 2540, 2546, 7939, 7940, and 7949 may be spurious under these conditions.
No action is required.
If other errors are reported by dbcc checkalloc, refer to this manual for information on how to deal with them.
If your operational environment allows it, put the questionable database into single-user mode prior to running dbcc checkalloc.
For the master database, refer to “Starting Adaptive Server in single-user mode” in the chapter “Server Recovery Tasks” in the most recent version of Troubleshooting and Disaster Recovery.
For other databases, use sp_dboption as follows:
1> use master 2> go 1> sp_dboption <database_name>, single, true 2> go 1> use <database_name> 2> go 1> checkpoint 2> go
Refer to “Fixing and preventing allocation errors” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery.
Refer to “dbcc” in the Reference Manual: Commands for information about dbcc checkalloc.
All versions
