USE Master ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE YourDatabase SET MULTI_USER
Categories
Kill All Active Database Connections
USE Master ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE YourDatabase SET MULTI_USER See Kill All Active Connections To A Database