Named Pipe Changes

Question

Named Pipe Changes

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
May 7, 2015 at 11:06 pm

#74429

Comments posted to this topic are about the item Named Pipe Changes
May 8, 2015 at 3:04 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 1

Thank you for the post, Steve, good one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Ed Wagner SSC Guru Points: 287024 More actions · Answer 2

This was one of those configuration questions I just don't do enough. They're always good. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

John Hanrahan Hall of Fame Points: 3825 More actions · Answer 3

John Hanrahan

Hall of Fame

Points: 3825

May 8, 2015 at 11:16 am

#1796673

I can't believe I knew this without looking it up!

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

I suspect most of you never change this, or have the need. I haven't done it since v6.5, but ran into a question recently on how to do it, so I built this.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Interesting question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

Steve Jones - SSC Editor (5/8/2015)
I suspect most of you never change this, or have the need. I haven't done it since v6.5, but ran into a question recently on how to do it, so I built this.

Never had the need 2 do it, but still a good question to refresh the mind & start the day with, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

murray-906152 SSCarpal Tunnel Points: 4889 More actions · Answer 7

Folks,

changing it is the easy bit.

Making use of the renamed pipe is another matter.

For a local instance, where a '2' has been added to the end of the default name, here is the way to get to it (via (re-)name pipes):

server=np:\\.\pipe\sql\query2

Cheers, Murray.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

Hany Helmy (5/10/2015)
Steve Jones - SSC Editor (5/8/2015)
I suspect most of you never change this, or have the need. I haven't done it since v6.5, but ran into a question recently on how to do it, so I built this.
Never had the need 2 do it, but still a good question to refresh the mind & start the day with, thanx.

I agree, never had to do this.

Revenant SSC-Forever Points: 42467 More actions · Answer 9

Iwas Bornready (5/11/2015)
Hany Helmy (5/10/2015)
Steve Jones - SSC Editor (5/8/2015)
I suspect most of you never change this, or have the need. I haven't done it since v6.5, but ran into a question recently on how to do it, so I built this.
Never had the need 2 do it, but still a good question to refresh the mind & start the day with, thanx.
I agree, never had to do this.

Nor did I, so I had to guess but somehow I got it right... Thanks, Steve!

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 10

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP