Проверка используемого протокола (для установки протокола Shared Memory)

select program_name, net_transport from sys.dm_exec_sessions t1

left join sys.dm_exec_connections t2

on t1.session_id = t2.session_id

where program_name like ‘1cv8%’