Database Stuck in Single User

use master
select * from master.sys.sysprocesses
where spid>50
and dbid = DB_ID ('database name')

--Kill the SPID Identified
KILL 100 -- replace the 100 with the SPID found in the previous query

ALTER DATABASE [database name] SET MULTI_USER WITH ROLLBACK IMMEDIATE