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.

All Forums  General SQL Server Forums  New to SQL Server Programming  *** Corrupt Full-Text Search ***

Author  Topic  benc007 Starting Member 6 Posts Posted - 2014-08-01 : 20:28:49 I have a few stored procedures that uses SQL full-text search. Everything works great, but when there is a problem with updating the index, all stored procedures fail. I get various errors such as: [Microsoft][ODBC SQL Server Driver][SQL Server]FORMSOF(INFLECTIONAL,Car) AND FORMSOF(INFLECTIONAL,Wash) [Microsoft][ODBC SQL Server Driver][SQL Server]Y [Microsoft][ODBC SQL Server Driver][SQL Server]A clause of the query contained only ignored words. As soon as I re-create the full-text index manually, these errors all go away. I have 2 options: 1) Email to myself using CDONTS when this happens so I can MANUALLY re-create the full-text index OR 2) Send an email to to myself using CDONTS when this happens and then AUTOMATICALLY re-create the full-text index How can I do this? Please help.