-- 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