# Resolve MSSQL OPENQUERY session hangs

### depends
[Sysinternals Suite](https://learn.microsoft.com/en-us/sysinternals/downloads/sysinternals-suite)

### solution description
Use `TCPView` from `Sysinternals Suite` to find connections which remote address are target linked server host.
Then do `close connection` from contextmenu function.

Use following statement to query running sessions.

SELECT t.session_id, t.host_name, t.program_name, t.login_time, t.client_interface_name, t.login_name, t.status, s.text
FROM sys.dm_exec_sessions t
CROSS APPLY (
	SELECT s.text
	FROM sys.sysprocesses r
	CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS s
	WHERE r.spid = t.session_id
) s
WHERE t.[status] = 'running'
ORDER BY t.host_name, t.[login_time]