Software Applications Programming Errors and solutions.

To get details of protocols used in current connection in sql server you can execute following select query . You could know about Shared Memory,TCP/IP,Named Pipes,VIA (Virtual Interface Adaptor) on using below query. SELECT session_id,connection_id, connect_time, net_transport, net_packet_size, client_net_address FROM sys.dm_exec_connections