Re: full-Text Search questions

Thank you for the info... I will search SQL Server BOL for information. Can
one add this functionality to the search feature?

I don't think the big boss man will be too happy with the search funciton
not returning information from child-sites. To clarify:
TopCo Site
TopCo Site / Employees
TopCo Site / Employees / HR
TopCo Site / Contractors

If a search is performed from TopCo Site nothing ever will be returned from
TopCo Site / Employees / HR.

englebert: i have noticed you are very knowledgeable and helpful with your
posts to others; thanks for your support.


"Engelbert" wrote:

- 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: Return subquery rows as one delimited column
    ... and concatenates them together - this will be very slow!! ... For SQL Server 2005, there's a method that uses documented functionality ...
    (comp.databases.ms-sqlserver)
  • Re: I have two questions about the TableAdapter Configuration Wizard
    ... something to do with the difficulty in adding functionality to VS2005. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I want to have a TableAdapter that encapsulates a bunch of stored ... I might have 10 delete sprocs that I want to put into one ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: access to SQL Server 2.0 CE from .NET Framework
    ... You can use the remote application programming interface to accomplish this functionality of accessing a SQL Server CE database from your ... RAPI allows desktop apps to invoke function calls on your Windows CE device while the device is connected via ActiveSync to the desktop. ... you could write a device resident app which performed SQLCE functionality and call this app from your desktop. ...
    (microsoft.public.sqlserver.ce)
  • Re: Common Objects in Management Studio?
    ... A lot of that functionality can be replaced by templates that you can add ... Open Template Explorer and right-click on the top node, ... the window opens, you can dock it somewhere in the Management Studio shell. ... >> I can't seem to find the equivalent of the Common Objects in SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Re: full-Text Search questions
    ... I just looked at some of the third party WSS replacements. ... I ended up going with Advis and changing the stored procedures to do more ... TopCo Site / Employees ... It's an SQL Server function so the SQL Server BOL might be a good place ...
    (microsoft.public.sharepoint.portalserver.development)