USE master 
SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('MyDB') 


ALTER DATABASE [mydb] SET OFFLINE WITH
ROLLBACK AFTER 30 SECONDS
OR

ALTER DATABASE [mydb] SET OFFLINE WITH
ROLLBACK IMMEDIATE