Full Text search does not always return expected results.

Version 1

    Details

     

    When using the searching functionality in HEAT Service Management the results may not be what the user was expecting.  

    For example: "IT Service Management" will not be found when searching for "IT Service" or "IT".

     


    Resolution

    Certain words are considered by the SQL Server Full Text searching mechanism to be "noise" words.  These words are not used by the Full Text searching process.


    The following SQL Command can be used to check how the Full Text SQL Parser considers each word:
    select * from sys.dm_fts_parser(' "{text to check}" ', 1033, 0, 0);

    For example:
    The output of the SQL Command shows that the word "it" is considered to be a noise word and will not be searched on.