Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003

    Unhappy Unanswered: Full-Text search problem in Win2k

    I have designed a sql database which has more than three houndered thousands of records.
    for developing the application , I installed the DB on a windows XP professional.
    In order to gain the most performance and accuracy in Searches I defined a Full-Text search on it which was very fast and accurate(note:All the fields in the index are nvarchar and have Farsi data).But when I installed the DB on a Windows 2000 advanced server, The qureies for searching Farsi Keywords didn't work and the Error message was:"The query contained only ignored words".
    the settings for Both windows2000 and XP and the sql Servers installed on them were the same
    but It only worked on a Windows XP.
    Now I wonder if anyone have ever ran into such a problem ,and could tell me what should I do.
    Any advice or hint will be highly appreciated.

  2. #2
    Join Date
    Aug 2002
    MSDN article refers :
    To prevent the "The query contained only ignored words" error while doing a free text search for some search phrases, use the UpdateFullTextCatalogs.vbs script in the Program Files\Microsoft Commerce Server 2002\Support folder.

    Use the following command:

    UpdateFullTextCatalogs.vbs I
    You need to run this script every time you create a catalog.
    --Satya SKJ
    Microsoft SQL Server MVP

  3. #3
    Join Date
    Dec 2002
    Czech Republic
    Now we need somebody with Microsoft Commerce Server 2002.
    He will look on C:\Program Files\Microsoft Commerce Server 2002\Support\UpdateFullTextCatalogs.vbs and see what the switch "I" is doing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts