SELECT * FROM CONTAINSTABLE(ActiveJob,*,'C')
This query fails with:
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query contained only ignored words.
Fair enough but 'c' has been removed from the noise word files as I want to find people who have applied for C porgramming jobs.
This does work on my live system but not on Dev server, but I can't find what is wrong. I have rebuild thte FullText catalog.
Any thoughts?
Thankyou!