APPROPRIATE request that does not recognize small words

Question

I use CONTAINSTABLEto search for two columns of a table. When a search contains small words, such as "the" for "a", the search does not return results, even if they are actually present in the column.

A quick example. The selected column contains text. "The system must be updated"

The following SQL returns 0 rows

SELECT     * FROM Incident WHERE (TicketNumber IN (
SELECT TicketNumber FROM         [Action] FT_TBL INNER JOIN
CONTAINSTABLE(Action, Text, '"system" AND "needs" AND "to" AND "upgraded" AND NOT "Search Summary"') KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY]
UNION
SELECT TicketNumber FROM [Incident] FT_TBL INNER JOIN
CONTAINSTABLE(Incident, Subject, '"system" AND "needs" AND "to" AND "upgraded"') AS KEY_TBL ON FT_TBL.TicketNumber = KEY_TBL.[KEY]))

Once 'to' is omitted, it works fine:

SELECT     * FROM Incident WHERE (TicketNumber IN (
SELECT TicketNumber FROM         [Action] FT_TBL INNER JOIN
CONTAINSTABLE(Action, Text, '"system" AND "needs" AND "upgraded" AND NOT "Search Summary"') KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY]
UNION
SELECT TicketNumber FROM [Incident] FT_TBL INNER JOIN
CONTAINSTABLE(Incident, Subject, '"system" AND "needs" AND "upgraded"') AS KEY_TBL ON FT_TBL.TicketNumber = KEY_TBL.[KEY]))

How CONTAINSTABLEcan you use with these smaller words, or should they be completely eliminated? If these smaller words are really significant in the search, how can they be included in the search?

Answer 1

" ", , . .

. - - BOL.

Answer 2

, . -, . "to", "be", "the", "for" ..

:

SQL Server 2005 MSSQL\FTData\noiseENG.txt.
" Sql Server 2005"