single_user mode - database locked
Posted on 2006-11-13
I set my database to single_user mode to restore the database this morning. The db was successfully set to single_user mode, but I cannot restore the database and it shows that there is one connection open to the database. I ran sp_who and it shows my login, but I've closed query analyzer and I don't see where I have a connection still open????
Can anyone help? I can't do anything now to the database because it is in single_user mode.
Thanks for any help.