September 8, 2007 at 10:26 pm
If I am trying :
SELECT * FROM table WHERE Statement LIKE '%SIMPSON BART%'
I get 3 rows.
But if I try:
SELECT * FROM table WHERE FREETEXT(Statement,'SIMPSON BART' )
I get none.
In fact it doesn't matter what I am typing in the 2nd param of the FREETEXT - I get nothing.
Notice (just to avoid some questions) :
1. MS SQL Server Search Service is up & running!
2. I've defined already a full-text catalog for that table (and the index is fully populated).
3. Version: SQL Server 2000 Standard Ed. SP3 (don't laugh on me please.... not my fault)
And I have another question: how can I verify that the full-text index was created correctly ??? (I've seen in the log, at the approximative moment of the creation of this index a message like 'not enough memory' but without any notice about during what operation this error appeared .... I have the external files created in the folder I specified at the moment of creation, but just in case ...
September 10, 2007 at 5:19 am
Your best bet is to drop the index and rebuild it if you're not sure it's created correctly. There is no way, that I know of, to check and verify that it was created correctly.
Sorry.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply