Post reply

Can I use sys.dm_exec_connections to determine if a connection is using Named Pipes?

  • December 10, 2014 at 11:22 am

    #313664

    More specifically, would the net_transport column tell me this?

    MSDN (here) indicates that column "Describes the physical transport protocol that is used by this connection."

    Running a quick select against the DMV I see mostly TCP, a couple "session," and a few "Shared memory" (which when joining to sys.dm_exec_sessions show these are from the SQL server itself.)

    We're supposed to have Named Pipes disabled, yet it is currently enabled on this server...

    Thanks

  • December 10, 2014 at 2:11 pm

    #1763902

    Yes, the net_transport column of sys.dm_exec_connections will let you know if the connection is named pipes. It actually shows up as "Named Pipe".

  • December 10, 2014 at 3:04 pm

    #1763912

    That's what I was hoping to hear, thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply