BAck up of 5GB database run for 12 hrs and when I investigate things are pointing toward FullText search on the database. I rebuild FTS catalogue but problem still persists. So I t …

Hi, We have the full text search table and are using CONTAINSTABLE to search in the fulltext search column, its workingfine, but we have a requirement that we need to return resul …

Is there a way to get know about when the full-text index is updated and ready for use after an insert or update statement occured in a table on which automatic change tracking is …

hi, The query select * from tablename where contains(tablename., '"001"') is not returning any value but, select * from tablename where contains(tablename., '"BDJ"') is wor …

Is this still a valid point: Microsoft has made it quite clear that the only way the Full Text Search service is supported is if it is running under LocalSystem. This came from an …

Hello Everone, I am using Full Text Search for our Search Algorithm. Description: Say there is a table called as Table1 which contains following columns Pls. Note: Columns of Ta …

I have this sql query where I'm trying to use CONTAINS to search the title field. But I get this error. "Cannot use a CONTAINS or FREETEXT predicate on column 'Title' because it …

If I populate a temporary table or a table variable, is there a way to search it with CONTAINS?

Can someone help me out, when I try to drop a full-text catalog I get the following error. TITLE: Microsoft SQL Server Management Studio Drop failed for FullTextCa …