Sharepoint FullTextSQLQuery index will not clear

After resetting the crawled content from my shared service I can still see all of the indexed data by using a FullTextSQLQuery. If I try searching using the OOB search on my site, I see no results, and the Props table is cleared in the database.

Any clue as to why this is happening? I am planning to create a web part for searching using FullTextSQLQuery, and I'd like to understand this be开发者_开发问答havior. Maybe it archives the crawled content and OOB searches ignore archives somehow?

The index is not stored on the database but the file system.

Open central administration

1. Select your SSP from the menu on the left under "Shared Services Administration"

2. Under the search header, select "Search Settings"

3. Within the page that loads (Configure Search Settings) you can do 1 of 2 things. Either select "Reset all crawled content".

Make sure which version of FullTextSqlQuery is being used. Microsoft.Sharepoint.Search.Query.FullTextSqlQuery is the WSS version and (from what I can figure out) actually retrieves another index located at database=WSS_Search_XXXX path=Program Files\Microsoft Office Servers\12.0\Data\Applications\\

The MOSS version is Microsoft.Office.Server.Search.Query.FullTextSqlQuery and it will use the corresponding shared service index for the site you instanciate it with.

As far as resetting the WSS index.. still not sure about that.