I am trying to get to the bottom of some weirdness. Yesterday I enabled a fulltext index on a table in SQL Server 2012 running on one of our LAN servers. I used the Wizard and set the index to update automatically. I had put some test data into the table and ran some CONTAINS queries and they worked fine.
Today I added some more data to the table and ran some CONTAINS() queries, and they failed with this error message:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'foo' because it is not full-text indexed.
What could make the fulltext index ephemeral? How can I get the status of fulltext indexing in this database, including which tables have been indexed?
When I go back in to the Fulltext Wizard to recreate the indexes, the catalog that I created is still present.
EDIT: I did confirm that there were data in the table. Test queries were working. Nothing was deleted, but there was indeed some kind of anomaly overnight that caused the server to shut down. Is the definition of the fulltext index stored in the Master database?