To kill all the users in the current database run:

USE [master];
GO

DECLARE @Kill nVARCHAR(4000) = ”;

SELECT
@Kill = @Kill + ‘kill ‘ + CONVERT(VARCHAR(5), session_id) + ‘;’
FROM
sys.dm_exec_sessions
WHERE
database_id = DB_ID(”);

EXEC sys.sp_executesql @Kill;