Error 2572

Severity

10

Message text

Database '%S_DBID' is not in single user mode - may find spurious allocation problems due to transactions in progress.

Explanation

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.

Action

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.

Additional information

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.

Versions in which this error is raised

All versions