The information in this article applies to:
BUG#: 14032 (6.00) SYMPTOMS
When you use SQL Enterprise Manager (SEM) to change the database option to
single user, if more than one user is using the database, the CHECKPOINT
command will fail and the following error is shown by SEM:
WORKAROUNDTo reset the 'single user' database option, you must use the system stored procedure sp_dboption. STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.0. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
If you clear the single user option and click OK again, the same message is
shown. In order to exit the "Edit Database" window, you must click the
Cancel button. If you "edit" the tempdb database again, and look at the
database option, the single user option is still checked. You are unable to
clear the single user option and click OK to reset the change. The above
error is shown again until you click Cancel to exit.
Additional query words: sql6 sem
Keywords : kbtool SSrvEntMan kbbug6.00 |
Last Reviewed: March 25, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |