ALTER DATABASE YourDatabase SET SINGLE_USER With ROLLBACK IMMEDIATE USE [master] ALTER DATABASE YourDatabase SET MULTI_USER;