named pipe

Question

Post reply

named pipe

bryan van ritter

SSCrazy

Points: 2270
More actions
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

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

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

OriginalWHY Mr or Mrs. 500 Points: 524 More actions · Answer 1

OriginalWHY

Mr or Mrs. 500

Points: 524

June 20, 2009 at 1:04 pm

#1012875

HI

Try

Select @@servername

bryan van ritter SSCrazy Points: 2270 More actions · Answer 2

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

OriginalWHY Mr or Mrs. 500 Points: 524 More actions · Answer 3

Hi

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

I'm replying from my mobile

bryan van ritter SSCrazy Points: 2270 More actions · Answer 4

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

kenglish Grasshopper Points: 11 More actions · Answer 5

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.

MannySingh SSChampion Points: 12465 More actions · Answer 6

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

bryan van ritter SSCrazy Points: 2270 More actions · Answer 7

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.