[dba-SQLServer] comman to configure pipes-CLICONFG

Hello Jean-Paul,

I was literally clearing out the emails, then I was going to post this
question to StackOverflow.

Glad you found it, how did you get it eventually?

Mark



On 17 June 2010 21:44, Jean-Paul natola <jnatola at hotmail.com> wrote:

>
> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>