Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nmg196
Yak Posting Veteran
70 Posts |
 Posted - 2009-05-12 : 14:04:28
|
| Hi,I have a table which has Full Text Search enabled on a couple of the columns with automatic change tracking enabled. If I insert a new row into that table, the new entry cannot be found using FTS, but all other entries can be found OK. The only way I can get it to be found using CONTAINS is if I force a Full repop.Change tracking is enabled and after a bit of googling, I've also added a timestamp column to this table. If I right click on the catalog under "storage" the population status says "Processing notifications" however it seems to stay in this state indefinitely, even though there are only 8000 rows in the table and I have only altered one of those rows since the last full pop. I've even tried rebuilding the catalog from scratch.Does anybody know what I'm doing wrong or why this might not be working?Thanks,Nick |
|
|
nmg196
Yak Posting Veteran
70 Posts |
Posted - 2009-05-15 : 04:05:29
|
| OK I've fixed this now.... It turns out there was some kind of deadlock between a hung backup process and MSSEARCH. |
 |
|
|
|
|
|
Full text search - change tracking not working