Jacob Wilkins (2/9/2016)

---

I haven't worked with full text search much, but as I recall it doesn't support that sort of suffix search. It supports a prefix search, like you're already...

When I do this, it has less results than when I use with the double quote and the...

I've deleted the catalog and the index. and recreated based on your scripts.

Still same results though

Igor Micev (2/9/2016)

---

1) Check that the service "SQL Full-text Filter Deamon Launcher (SQL20XX)" is running. If not it must be running in order to use catalogues.

2)

Run this to see...

Igor Micev (2/9/2016)

---

Did you get the following error message for the second query

Msg 7601, Level 16, State 2, Line 5

Cannot use a CONTAINS or FREETEXT predicate on table or indexed...

Hi Scott,

When I try to run the scripts I get:

'Online index operations can only be performed in Enterprise edition of SQL Server.'

Is there a way to do this in...

As asked also the results in grid format.

Hi Scott,

In attachment the results (hopefully good format)

Peter

Hi,

Sorry for the late response, was a weekend out of town. The zip file should be attached.

Peter

Hi Steve,

I checked the query execution plan, however it is the first time I am looking in such thing, and I have no idea how to see what is wrong....

sgmunson (7/10/2014)

---

Have you looked at the query's execution plan? This would likely reveal the reason. Also, is there more than one record in the table...