What is named pipe?

When I use Sql, I can choose between named pipe and TCP/IP.

I never heard about named pipe before, what is it?

It's a network protocol (as is TCP).  Microsoft have written a few
net-libraries for SQL clients to communicate with SQL servers and those
net-libraries are targeted as specific network protocols; there's one
for TCP sockets, one for named pipes, one for shared memory, etc.

This is documented in BOL:
Client Net-Libraries and Network Protocols
<http://msdn.microsoft.com/library/d...
ient_8uwj.asp>
Named Pipes vs. TCP/IP Sockets
<http://msdn.microsoft.com/library/d...>
_1a_7fcj.asp>

--
*mike hodgson*
http://sqlnerd.blogspot.com



ad wrote:

>When I use Sql, I can choose between named pipe and TCP/IP.
>
>I never heard about named pipe before, what is it?
>
>
>
>

Named Pipes is a egacy Windows interprocess communications abstraction that
allows transparency over various underlying communications mechanisms.  It
was the original mechanism that SQL Server used for local interprocess
communications, however now SQL Server uses a shared memory netlib instead.
And TCP/IP has become almost universal as the client/server protocol.

Basically, you don't want to use Named Pipes unless you have a legacy
situation where you need to enable communications with an existing client or
server that is using Named Pipes and can't be changed to use something else.

--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com


"ad" <flying@wfes.tcc.edu.tw> wrote in message
news:Ow6QgWDVGHA.1728@TK2MSFTNGP11.phx.gbl...
> When I use Sql, I can choose between named pipe and TCP/IP.
>
> I never heard about named pipe before, what is it?
>