Re: SharePoint Services  SQL 2005

My apologies, I misunderstood your question.
It is strange that it does not work for you in SQL Server 2005.
I don't have a setup to verify at the moment.
Maybe someone else may have some ideas...

Thanks
C
http://spaces.msn.com/cjvandyk



"furthest" <furthest@xxxxxxxxx> wrote in message news:furthest@xxxxxxxxx:

I dont get it, my example was taken from the built in documentation... which
is quoted in full below.


Get the desired search results
Your search did not return any results
Ensure that all words are spelled correctly.

Try different keywords or synonyms to describe the item for which you are
searching.

Try more general keywords.

Your search returned too many results
Use more search words. You can include up to 255 characters.

Use more specific keywords. For example, rather than searching for "art,"
search for the name of a specific artist or work.

Notes on the search engine
The search engine automatically includes variations of words based upon the
base stem, such as plurals. For example, searching for the word "page" also
returns results for "pages."

You cannot use the asterisk "*" character.
The search engine does not support Boolean functions such as AND and OR.

The search engine automatically ignores common words such as "the," "it,"
and "by" as well as single-digit numbers.

The search engine is not case sensitive.

Attachments to list items do not appear in search results.

You cannot search for information in items (rows) that are not included in
the current view. For example, if you search in a view that shows only items
created by you, any items created by another user are not searched. However,
searches include all information in the items that are not filtered, including
information in columns that are hidden. Searches also include information
in items that exceed the current view's item limit.
There may be an internal error on the search server. Contact your server
administrator for more information.

C2003 Microsoft Corporation. All rights reserved.



Hello Cornelius J. van Dyk,

> That search example you listed does not work in SQL Server 2000
> either.
> The reason is that WSS search uses SQL Full Text Search.
> As such, only full word matches as returned i.e. no fuzzy logic is
> applied thus "pages" will not be returned on a search for "page".
> This is designed behavior.
> Thanks
> C
> http://spaces.msn.com/cjvandyk
> "furthest" <furthest@xxxxxxxxx> wrote in message
> news:furthest@xxxxxxxxx:
>
>> Has anyone noticed some significant differences with the way WSS
>> works with SQL 2005?
>>
>> Maybe I'm missing something, but it appears that the backup
>> functionality
>> is not available. The documentation outlining "Using HTML
>> Administration
>> Pages to Back Up and Restore Data" doesn't apply as the options are
>> not there
>> al all.
>> Also, testing shows that "The search engine automatically includes
>> variations of words based upon the base stem, such as plurals. For
>> example, searching for the word "page" also returns results for
>> "pages."" - Does not work with SQL 2005.
>>
>> Any feedback would be appreciated...
>>

.

Relevant Pages

  • Re: Full Text Max Size?
    ... and depending upon what your is your SQL Server version and SP ... > from the OLE DB provider 'Full-text Search Engine'. ... > OLE DB error trace [OLE/DB Provider 'Full-text Search Engine' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to Generate Snippets of the doc by Full-text Search Engine
    ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ... send the entire results back to the client and have the hit marked up ... Actually speaking, my system is just like a enterprise search engine, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Nested Nodes in XML from a table
    ... > Well considering that many persons would be accessing a search engine; ... > who knows how many of them will be in the future acessing at the same ... > is much faster than accessing the actual sql server. ... I don't have Books Online 2005 on this machine, ...
    (comp.databases.ms-sqlserver)
  • doing a search
    ... and using SQL Server 2000. ... I need to add a search engine. ... the criteria typed into the box, and rank them and highlight key words. ... sample code would be best. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Number of documents vs rank in FTS
    ... especially if I start writing procedures to query the index using ... document frequency of a boolean query in SQL server*, ... > document collection or the frequency that words occur compared to the ... >> frequency to penalize the number of occurrences for keywords common ...
    (microsoft.public.sqlserver.fulltext)
Loading