Re: full-Text Search questions

- Full text search doesn't include Booleans or wild cards so Net won't find
NetSuite but it would find Nets (i.e. another version of Net)

Where is a good place to find out more about Full-text searches?

It's an SQL Server function so the SQL Server BOL might be a good place to
look. Either that or search Google ...

Will 'child sites' also be searched?

No. The functionality in STS was to search the entire set of sites. There
were complaints so the functionality of WSS (and the WSS part of SPS 2003)
is to search a single site only.

Engelbert

"rogge" <rogge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1490848E-C8B5-4E25-BF75-62DD890D91CF@xxxxxxxxxxxxxxxx
Ok i had to un-tick and re-tick "enable full text search" on the central
admin page and now have results; however, i assumed that the seach would
be
a "contains" type search, *Like* y'know *Like* oh my god... <wobbles head
back and forth; the large poka dotted bow stays firmly fixed to the
tight-pony-tailed hair> (apoligies in advance for poor SQL and high school
cheer leader referenes... on to the question)

SELECT <Field> from <Table> WHERE <Field> LIKE "*<SearchTextString>*"

but no avail.. for I seek "Net" and "NetSuite" is not returned. Yet,
querying "NetSuite" returns a record. And Child-Sites are not
searched....

"rogge" wrote:

I am trying to get a full-text search to work. the central admin. site
shows
that full-text search is enabled and i have a 'search' box in the top
left of
the share point site. Also in the SQL admin (on the server) Full-text
search
is enabeled and started. From what I have read, i have completed all
tasks
necessary for this functionality, but with no positive result.

When a search for a document was performed, nothing was returned. the
search phrase is contained in the document and in the document title.

Do SQL Server indexes need to be created? Can this be done
automatically?
What fields are to be used?

Where is a good place to find out more about Full-text searches?

Will 'child sites' also be searched?

SharePoint Portal Server 2003, SP1 / SQL Server 2000

Thank you for helping me trouble shoot this function.


.

Relevant Pages

  • Re: Database terminology
    ... Jeff Boyce wrote: ... opinion which does not reflect SQL DBMS 'best practice'. ... fundamental area of Jet 4.0 functionality from an inexplicably biased ... I think it a shame when people in the Access community use language ...
    (microsoft.public.access.tablesdbdesign)
  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: an old geezer running visual studio for the first time
    ... > Maybe your idea of OOP is not as complete as it can be. ... so instead of placing common functionality in utility ... > functionality is in a common base class. ... >> closing rapidly the connetion again) and only change data by way of SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: an old geezer running visual studio for the first time
    ... Maybe your idea of OOP is not as complete as it can be. ... sounds more like componentization than OOP in general. ... functionality is in a common base class. ... > closing rapidly the connetion again) and only change data by way of SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DataRelation left outer join different database types
    ... It lets you perform complex SQL SELECT ... other is stored in SQL Server. ... It seems like the DataRelation only supports inner joins, ... however maybe I'm missing parts of the functionality. ...
    (microsoft.public.dotnet.framework.adonet)