VQSM Full Text Indexing fails in SQL

A quick one at the moment to get the ball rolling, I just came back from a client that uses VQSM with SQL and they had an issue with full text indexing whereby their periodic update failed continuously.

VQSM has a scheduled job that should run to maintain the full text index for the call comments field. If you find that the job fails then it is worth checking that the full text index has been created and that nobody has subsequently deleted it.

You can find an entry for the index using enterprise manager by expanding the database and clicking on Full-Text Index. You should have an index named Call_Comments listed. If not you wiull need to create it using the following from Query analyser.

use [Database_Name] sp_fulltext_catalog N'Call_Comments', N'create'

Posted by: David Bland (Transforme Associates Limited)
Software: VQSM (Datawatch)
Version: 7.x
Database: Microsoft SQL