Hi I have a table that is being updated in a batch over night. I can there perform a query search against this using a fulltext CONTAINS statement. This has been working perfectly well until recently when despite the records still being added to the table the full text search for the new records is not working. Old records fine but new one no.
I have been trying to think what changes have been made to the database but it realy has been minimal and I haven’t altered the fulltext columns themselves. The incoming data is still in the same format. The new records do exist and can be queried by statements without the CONTAINS statement in it.
Any suggestions why the new records would not be found.?