-- MSSQL
접속한 클라이언트의 접속유형
어린왕자악꿍
2010. 3. 23. 12:18
SELECTCASE
WHENCHARINDEX('mssh',p.net_library)> 0 THEN'Shared Memory'
WHENCHARINDEX('nmpn',p.net_library)> 0 THEN'Named Pipes'
WHENCHARINDEX('msrp',p.net_library)> 0 THEN'Multi-Protocol'
WHENCHARINDEX('msso',p.net_library)> 0 THEN'TCP/IP Sockets'
WHENCHARINDEX('mssp',p.net_library)> 0 THEN'Novell IPX/SPX'
ELSEp.net_libraryENDASConnectionNetworkLibrary
FROM MASTER..SYSPROCESSESASp
WHERE p.spid=@@SPID