kill datebase session id

Use master

SELECT session_id, login_name, host_name, program_name

FROM sys.dm_exec_sessions

WHERE database_id = DB_ID('yourdatabasename');

KILL seesion Id(SSID);