[dba-SQLServer] comman to configure pipes

Jean-Paul natola jnatola at hotmail.com
Wed Jun 16 18:07:10 CDT 2010


ths one im looking for is run from the winndows  run line/command propmt
 
its one single word  and it shows the Named Pipes that establesh the connection between the client os and the sql databse on the host OS.
 
























Jean-Paul Natola








----------------------------------------
> Date: Sun, 13 Jun 2010 12:24:49 +0100
> From: marklbreen at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 		 	   		  
_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5



More information about the dba-SQLServer mailing list