DECLARE @TARGET INT
WHILE 1=1
BEGIN
	DECLARE KILLCONS CURSOR LOCAL FAST_FORWARD FOR
		SELECT SPID FROM MASTER..SYSPROCESSES WHERE DBID = DB_ID('DB NAME') AND SPID >=50
	OPEN KILLCONS
	FETCH NEXT FROM KILLCONS INTO @TARGET
	WHILE @@FETCH_STATUS = 0
	BEGIN
		EXEC ('KILL '+@TARGET)
		FETCH NEXT FROM KILLCONS INTO @TARGET
	END
	CLOSE KILLCONS
	DEALLOCATE KILLCONS
END

ALTER DATABASE Northwind SET SINGLE_USER WITH ROLLBACK IMMEDIATE
EXEC sp_dboption 'Northwind', 'single user', 'FALSE'