[dba-SQLServer] comman to configure pipes-CLICONFG

cliconfg

 
 
 
 
 
 
 
 
 
 
Jean-Paul Natola
 



 
> From: jnatola at hotmail.com
> To: dba-sqlserver at databaseadvisors.com
> Date: Wed, 16 Jun 2010 19:07:10 -0400
> Subject: Re: [dba-SQLServer] comman to configure pipes
> 
> 
> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
 		 	   		  
_________________________________________________________________
The New Busy is not the old 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_3