Full-text search locks up database - error 0x8001010e
- by Stewart May
Hi
We have a full-text catalog that is populated via a job every 15 minutes like so:
ALTER FULLTEXT INDEX ON [dbo].[WorkItemLongTexts] START INCREMENTAL POPULATION
We have encountered a problem where the database containing this catalog locks up. There are a couple of scenarios, we either see the job execute and the process hang with with a…