SQL Server Error Msg 31202 – Reconfiguring the search property list of the full-text index has truncated the existing data in the index. Until the full-text index has been fully repopulated, full-text queries will return partial results. The ALTER FULLTEXT INDEX SET SEARCH PROPERTY LIST …; statement automatically issues a full population, but if the ALTER FULLTEXT INDEX statement specified the WITH NO POPULATION clause, you must run a full population on the full-text index using ALTER FULLTEXT INDEX ON START FULL POPULATION;. This is a warning.

In this blog post, let’s learn about the error message “31202 – Reconfiguring the search property list of the full-text index has truncated the existing data in the index. Until the full-text index has been fully repopulated, full-text queries will return partial results. The ALTER FULLTEXT INDEX SET SEARCH PROPERTY LIST …; statement automatically issues a full population, but if the ALTER FULLTEXT INDEX statement specified the WITH NO POPULATION clause, you must run a full population on the full-text index using ALTER FULLTEXT INDEX ON START FULL POPULATION;. This is a warning.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

31202 – Reconfiguring the search property list of the full-text index has truncated the existing data in the index. Until the full-text index has been fully repopulated, full-text queries will return partial results. The ALTER FULLTEXT INDEX SET SEARCH PROPERTY LIST …; statement automatically issues a full population, but if the ALTER FULLTEXT INDEX statement specified the WITH NO POPULATION clause, you must run a full population on the full-text index using ALTER FULLTEXT INDEX ON START FULL POPULATION;. This is a warning.

Reason for the Error

To be update soon…

Solution

To be update soon…