You can also see who is holding a lock on the database by querying sys.dm_tran_locks.

Kill the session_id and change to multi user by executing ALTER DATABASE db SET MULTI_USER.