Disconnect Users
Posted by Jugal Shah on January 24, 2011
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.
