If your database is stuck in single-user mode, connect to 'master' database and right-click on your stuck database. Click Properties->Options, scroll to the bottom and change “Restrict Access” value to “MULTI_USER”.
How to connect to master db?
Easy. First, close any query windows that you have opened for your stuck database.
Then click on 'master' and open a new query window for it.
Now you should be able to right-click on your stuck database.
Hope this helps someone.