single user mode

[Lily]

I had encounter the problem of setting the database option to single user mode. Everytime, I check the `current activity` or run `sp_who`, I could not see anyone using the specific database(A), but when I go the the database management or use `sp_dboption` to set it to `single user`, the error message said like this all the time, " Attemp to set `database name(A)` to single user mode failed because the usage count is 8(ps. sometime said `7`). Make sure that no other users are currently using this database and rerun checkpoint." So, I had to shut down the server and restart, after I finish some modification on the database(A), I could not set back the database mode to normal either, I had to shut down the server again. Is there any easy way to make the setting work?

Any help or advice would be very appreciated.

[Jinachandran]

I have the same problem. I appreciate if any body could help.


On 6/25/98 4:05:22 PM, Lily wrote:
> I had encounter the problem of setting the database option to single user
> mode. Everytime, I check the `current activity` or run `sp_who`, I could
> not see anyone using the specific database(A), but when I go the the
> database management or use `sp_dboption` to set it to `single user`, the
> error message said like this all the time, " Attemp to set `database
> name(A)` to single user mode failed because the usage count is 8(ps.
> sometime said `7`). Make sure that no other users are currently using this
> database and rerun checkpoint." So, I had to shut down the server and
> restart, after I finish some modification on the database(A), I could not
> set back the database mode to normal either, I had to shut down the server
> again. Is there any easy way to make the setting work?

Any help or
> advice would be very appreciated.