Does WSS search filenames? I cannot find this in MSFT documentation for
SQL server or WSS. Please reply if you have any insights. Thank you.

Re: Does WSS search filenames? by Engelbert

Engelbert
Sat Jan 07 05:04:15 CST 2006

This

http://www.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=10

on what is covered by WSS search doesn't answer this specific question you
have (and I can't remember) but it refers to the WSS Administration Guide as
a source of complete information on this. So look at the Admin Guide ...

Engelbert

"Dawn" <dawn.m.hayes@gmail.com> wrote in message
news:1136589268.384378.238100@f14g2000cwb.googlegroups.com...
> Does WSS search filenames? I cannot find this in MSFT documentation for
> SQL server or WSS. Please reply if you have any insights. Thank you.
>



Re: Does WSS search filenames? by Kevin

Kevin
Mon Jan 09 12:52:56 CST 2006

Yes it does. This is the LeafId from the Docs table.

If you use SQL Enterprise Manager you can see what tables and columns are
indexed via Full Text Indexing. As in the following:-

Table Indexed Columns Description
UserInfo tp_Login, tp_Title, tp_Email Details of users that
have visited a site collection
Lists tp_Title, tp_Description Title and
description of lists
UserData nvarchar1 to nvarchar64
ntext1 to ntext32 Text based
custom columns for items in a list or library
Docs LeafId, Content Filename of
document and its content.


"Engelbert" <Engelbert@discussions.nospam.com> wrote in message
news:%23GqKao3EGHA.2300@TK2MSFTNGP15.phx.gbl...
> This
>
> http://www.asaris.de/sites/walsh/Lists/WSS%20FAQ/DispForm.aspx?ID=10
>
> on what is covered by WSS search doesn't answer this specific question you
> have (and I can't remember) but it refers to the WSS Administration Guide
> as a source of complete information on this. So look at the Admin Guide
> ...
>
> Engelbert
>
> "Dawn" <dawn.m.hayes@gmail.com> wrote in message
> news:1136589268.384378.238100@f14g2000cwb.googlegroups.com...
>> Does WSS search filenames? I cannot find this in MSFT documentation for
>> SQL server or WSS. Please reply if you have any insights. Thank you.
>>
>
>



Re: Does WSS search filenames? by Dawn

Dawn
Mon Jan 09 15:39:40 CST 2006

Forgive my lack of tech knowledge, but maybe I can piece together what
I understand and then someone can fill in the blanks...... WSS search
from MSFT Admin guide doesn't fully answer my question:
"[search] File types other than .doc, .xls, .ppt, .txt, and .htm: Not
by default. You can install customized SQL Server search filters to
search other file types."

Here is what we want to accomplish with "other file types"(scanned
Adobe pdf images-not OCR, jpg, and gif, for example)
1. install whatever filters are necessary to include these files in
FREETEXT searches
2. search these "other file types" by using SQL FREETEXT to search
custom list columns and filenames.

Right now, our pdfs, jpgs and gifs cannot be searched for content, so
we are hopeful steps 1 & 2 are possible. Can we do that?