Post reply

named pipe

  • June 20, 2009 at 7:13 am

    #135516

    i would like to do a simple query to obtain the named pipe information/name of my instance. i know where to find it in the registry, but would like to query it in sql server.

    thanks in advance

  • June 20, 2009 at 1:04 pm

    #1012875

    HI

    Try

    Select @@servername

  • June 20, 2009 at 1:44 pm

    #1012879

    thankx for thinking with me. i knew this option, but this gives me the servername. what i am looking for is the whole nine yards:

    np:\\......\pipe\MSSQL$.......\sql\query

    bryan

  • June 20, 2009 at 1:57 pm

    #1012881

    Hi

    There is the store procedure xp_regread. Check the master or msdb databases for the correct name.

    I'm replying from my mobile

  • June 21, 2009 at 10:48 am

    #1013048

    Hi,

    thanks again. xp_regread was correct spelled, but this is for reading the registry with t-sql. i've got several instances and for using this isn't so handy i think. i just want to know if there is a way to get this information from sql server with a simple command. i am still searching the net. but if you come up with another idea please tell me.

    bryan

  • June 23, 2009 at 8:28 am

    #1013979

    This article shows how to get to this info using WMI and old fashioned VB (page 3 mentions pipe configuration):

    http://www.docstoc.com/docs/4204611/WMI-for-SQL-Server-Philip-Pursglove-SQL-Server-comes

    this article shows how to use WMI from C#:

    http://www.csharphelp.com/archives2/archive334.html

    and this article shows how to create a CLR stored proc:

    http://www.simple-talk.com/content/print.aspx?article=314

    Put it all together and you can do what you want without using regread, however seems like quite a bit of trouble and a couple of extra layers of code to essentially do the same thing as regread.

  • June 23, 2009 at 8:36 am

    #1013991

    select * from sys.dm_exec_sessions

    select * from sys.dm_exec_requests

    select * from sys.dm_exec_connections

    you can join these 3 to filter more info, but connections and sessions should retuen you whats needed.

    Or sysprocesses.

    Maninder
    www.dbanation.com

  • June 23, 2009 at 11:38 am

    #1014135

    thanks for the suggestion, but i don't see the complete named pipe string. the only thing i see is the notification that the named pipe is used to connect to the database, but not which named pipe this is.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply