• RBarryYoung (3/9/2009)


    Great article, Brian. Is the Client_Host ip information still available about a session later on, or would I need to store it from a Logon Trigger like yours if I needed that?

    It's also available in sys.dm_exec_connections in the column client_net_address.

    K. Brian Kelley
    @kbriankelley