Posted by Alec on Tue, 12 Jan 2010, in SQL
I recently installed SQL 2008 on my machine and once I tried to restore a database, it failed as it complaint as the database was currently in use. In SQL 2005, we normally go to activity monitor to kill the process but this is a little different in SQL 2008. The easiest solution now is to run this little query.
alter database database name set restricted_user with rollback immediate