TechQA.

SQL Server CONTAINSTABLE working well but failing on a table

118 views Asked by At

I am having problems with Fulltext search on SQL Server 2008 R2. Basically I use CONTAINSTABLE and all works well with my tables but for some reason fails to return rows on one of the tables I am searching in.

I tried recreating the catalog and even recreating the table but no luck. Could this be a corrupt catalog or database?

sql-server-2008-r2 full-text-search containstable
Original Q&A
1

There are 1 answers

0
Lukas On BEST ANSWER

Recreating the database from scratch through scripts sorted this out. The database must have been corrupt.

Related Questions in SQL-SERVER-2008-R2

Related Questions in FULL-TEXT-SEARCH

Related Questions in CONTAINSTABLE

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json python-3.x ruby-on-rails .net sql-server swift django angular objective-c pandas excel

Trending Questions