sql server full text search: I performed the following search using MS Query Analyzer
(SQL 2000):
select * from kc_rawtext where contains (value,'"Account"')

however, all of my search always comes up empty/no
result. Is CONTAIN working in SQL 2000?

When I try the same type of search using LIKE, it works:

Uyen,
Can you confirm if you or someone else ran a successful Population on the
Full-Text Catalog for your table kc_rawtext? You can confirm this via the
server's Application Event log for "Microsoft Search" and MssCi source
events to confirm if the FT Catalog that was created for your table
kc_rawtext was correctly populated. You can also confirm that the FT Catalog
has more than one itemcount (row count) under the database icon in the
Enterprise Manager. Most likely this table's FT Catalog was not populated
successfully.

Regards,
John



[quoted text, click to view]

John,

where specifically or which folder do I go to in order to confirm in the
server's applicaiton event log for MS Search that the FT catalog was
created? What statement am I looking for in the log to confrim this?

I confirmed that the kc_rawtext does have records in it by running the
following query in the SQL Query Analyzer:
select * kc_rawtext.


*** Sent via Developersdex http://www.developersdex.com ***

Uyen,
On the server where you have SQL Server 2000 installed and this problem
exists, you would click on Start -> Programs -> Administrative Tools ->
Event Viewer. In the Event Viewer, you would click on Application and under
source you will see "Microsoft Search" (among other events) as well as
MssCi. If you click on these source events, for a successful Full
Population, you will see events such as the following:

Application Event log. Create FT Catalog
or start a Full Population and in the Application Event log, you will see
several "Microsoft Search" and MssCi source events , such as:

Event Type: Information
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3019
Date: 1/27/2004
Time: 3:25:45 PM
User: N/A
Computer: JTKWIN2003
Description:
The crawl on project <SQLServer$SQL2K SQL0000500008> has started.
....
Event Type: Information
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3018
Date: 1/27/2004
Time: 3:25:48 PM
User: N/A
Computer: JTKWIN2003
Description:
The end of crawl for project <SQLServer$SQL2K SQL0000500008> has been
detected. The Gatherer successfully processed 7 documents totaling 0K. It
failed to filter 0 documents. 0 URLs could not be reached or were denied
access.
....
Event Type: Information
Event Source: MssCi
Event Category: None
Event ID: 4103
Date: 1/27/2004
Time: 3:25:49 PM
User: N/A
Computer: JTKWIN2003
Description:
Master merge has completed on
f:\mssql80\mssql$sql2k\ftdata\sql0000500008\build\indexer\cifiles.

Note, the last event (MssCi) occurs at the end of either a Full or
Incremental Population.

It's not the your table row's count that needs to be confirm, but the FT
Catalog's. Click on Start -> Programs -> Microsoft SQL Server -> Enterprise
Manager and click on the server with this problem and click on the database
folder and the database that contains your table. Then click on the
Full-Text Catalog icon and you will find the FT Catalog for your table. If
you right-click on it and select properties, what is the itemcount (row
count +1) and the unique key count (number of unique non-noise words) ?

Regards,
John





[quoted text, click to view]