Full text index requires dropping and recreating - why?
- by Amjid Qureshi
Hi all,
So I've got a web app running on .net 3.5 connected to a SQL 2005 box.
We do scheduled releases every 2 weeks.
About 14 tables out of 250 are full text indexed.
After not every release, but a few too many, the indexes crap out.
They seem to have data in there, but when we try to search them from the front end or SQL enterprise we get…