Many times we want to restore the existing database or do DDL operation and often we are getting error Database is in use.


ALTER DATABASE databasename SET single_user WITH ROLLBACK IMMEDIATE 

You required only DBO rights on the target database, even you don’t have sysAdmin rights it will work for that particular database.