How to search the Microsoft SQL Full Text Search index

Published on Author JFLeave a comment

Use this query in SQL Management Studio to directly search the Full Text Search index.

select * from sys.dm_fts_parser('"search term"', 1033, NULL, 0)

Note that there are upcoming changes to FTI, including many deprecated functions, so if you’re using it extensively you probably have some work to do.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.