[dba-SQLServer] comman to configure pipes

Hello Jean-Paul,

I got this from stackoveflow

Also, I saw references to two sprocs sp_whois and the undocumented sp_whois2

HTH

Mark


Credit this to stackoverflow - I voted up the answer


SELECT

    conn.session_ID as SPID,

    conn.client_net_address as IPAddress,

    sess.host_name as MachineName,

    sess.program_name as ApplicationName,

    login_name as LoginName

FROM
    sys.dm_exec_connections conn

INNER JOIN sys.dm_exec_sessions sess ON

    conn.session_ID = sess.session_ID

WHERE
    conn.session_ID = @@SPID





On 12 June 2010 01:14, Jean-Paul natola <jnatola at hotmail.com> wrote:

Whats the name of the command that lets you see how you are connecting to a
sql server?



i used once about  a year ago i know you run it from the run line
_________________________________________________________________
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com