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.?
The two processes doing the indexing are msftesql.exe and mssearch.exe. You should be able to see these in Task Manager. You can control the sql server process (msftesql.exe) from the Services Management
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…