FIX: DBCC NEWALLOC May Cause Incorrect Database Usage Count (165579)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q165579
BUG #: NT: 13108 (6.00)
16262 (6.50)
SYMPTOMS
After you run the DBCC NEWALLOC command, the database usage count is left
one more than the actual count. This would prevent you from setting the
database in single user mode. The count remains incorrect until SQL Server
is restarted.
WORKAROUND
Run DBCC CHECKALLOC instead.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5. This problem has been corrected in U.S. Service
Pack 3 for Microsoft SQL Server version 6.5. For more information, contact
your primary support provider.
MORE INFORMATION
The same problem may occur if you run "DBCC FIX_AL (database_name)".
Modification Type: | Major | Last Reviewed: | 10/16/2003 |
---|
Keywords: | kbBug kbfix KB165579 |
---|
|