Does SQL Server only look at its full text catalog when there is a CONTAINS in the query? Or would it also do that for a LIKE query?
Background: Our application used to use Full Text Catalogs in SQL Server and CONTAINS queries to do Full Text Searching. Last year we switched to Lucene and do all of our own indexing now. So we no longer rely on the Full Text Catalog (in fact we remove it).
A customer claims they turned on the Full Text Indexing in SQL Server and now our app is returning hits for queries that it wasn't before. There are absolutely ZERO sql queries run against our db with the CONTAINS clause, so I just wanted to verify that this is the only SQL clause that cause SQL Server to look at a Full Text Catalog.