all groups > sql server full text search > july 2003 > threads for july 1 - 7, 2003
Filter by week: 1 2 3 4 5
When to use Full Text Indexes
Posted by jim-watters NO[at]SPAM rogers.com at 7/7/2003 9:58:47 AM
Hello,
We are discussing the requirements of a database application with one
of them being the ability for users to serch a text field that
contains a description of a play in a hockey/basketball game.
For example: Wayne Gretzky power play goal was his 50th of the year
My impression is th... more >>
SQL Server 6.5 sp5a
Posted by Steve Colwell at 7/7/2003 3:33:50 AM
I am trying to install the sp5a service pack on SQL 6.5.
I am getting an error message of "setup initilisation
could not be successfully completed. ISQL.exe could not
be executed. Please check the relevant .OUT file." I
first received this type of error on the cfgchar.exe
file, but i got r... more >>
Does RANK and weightage goes hand in hand
Posted by Abhijeet Raje at 7/5/2003 4:30:05 PM
Hi,
ranking is determined by a formula that accounts
for the frequency of the word in the document/row compared with the
frequency of the
word occuring in all documents/rows weighted against the total number of
unique
non-noise words in your catalog.
Does this means that if I have fulltext ... more >>
CONTAINSTABLE v/s FREETEXT
Posted by Abhijeet Raje at 7/5/2003 12:52:28 PM
Hi All,
I have one table Customers in Northwind database.
While performing FreeText search I want to give weightage ON Columns for
a searched phrase.
CompanyName weight (1) ContactName weight
(.7)
ContactTitle weight (.5) ... more >>
"Query Contains Only Ignored Words" (#7619)
Posted by Dino M. Buljubasic at 7/4/2003 3:30:55 PM
> I am having a problem when querying data from database.
> Some of the queries throw an exception and I don't know how to fix it.
>
> The error I get is "Query Contains Only Ignored Words" (#7619)
>
> Any help would be appreciated
--
Dino Buljubasic
Software Developer
http://rivusglob... more >>
Can not enable fulltext..
Posted by Peter Thygesen at 7/4/2003 11:50:13 AM
Microsoft Search is running as LocalSystem
and
MSSQLSERVER as .\Administrator
But I can not run sp_fulltext_database 'enable'
I still get the error message
(1 row(s) affected)
Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46
The Microsoft Search service canno... more >>
full text indexing
Posted by Kelly at 7/2/2003 9:35:56 AM
I have a database that has one column that I've given full-
text indexing so that I can do searches and what not.
The only problem is that every time data is added to the
index, it doesn't automatically become fully indexed and
consequently can't be fixed.
I know i'm doing something wro... more >>
|