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