Can someone please tell me what is meant by a file share?

I'm doing a little reading on MS Sql Server and they talk about how
you can connect to the sql server through a named pipe.
I'm guessing that a file share means a specific service running on a
server. Is this correct?
The book says the following:
When you connect to a file share you use a Universal Naming Convention
path to a file server: \\FILESERVER\Sharename.

To connect to a named pipe, you connect to a share of the form:
\\COMPUTER\pipe\sql\query

Thanks Hope you can clear this up for me.

nick (cupofjava1961 (AT) aol (DOT) com) writes:
A file share is a directory to which access have been opened to users
on other machines. You can set up a file share on your machine, by right-
clicking a directory in Explorer and select Sharing and Security. (In
Windows XP.)

Yes, this the syntax to refer to a disk on a different computer, although
it is also possible to map a drive letter to a remote disk.

All this has very little to do with SQL Server, but is common knowledge
about Windows.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Feb 25, 6:25 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
No Erland,

This is completely the wrong answer. Some people should not attempt to
answer questions that they have absolutely no answer for. At any rate,
a shared pipe has more to do with a Unix client/odbc connection to a
MS-SQL server using Unix socket/lock files. Anyone who really needs to
know the answer to this can take a look at http://en.wikipedia.org/wiki/Unix_file_types
.... perhaps this will give some of you something to look at.

HTH,

Carl Tegeder
MS-SQL MVP
Advanced Master MS-SQL Administrator