Hi Steve,

Thank you for your solution. However I can't seem to get this working in the same way as LIKE '%<term>%' !

When I use the FREETEXT or CONTAINS only 2...

Hello Jack,

Thank you for your response.

As you are a T-SQL person, I was thinking about the following approach I would like to discuss. As the problem lies in % prior...

Hi Andre,

This is the code producing the results I want:

SELECT

*

FROM

[dbo].[companies] a

WHERE

a.[organisationname] LIKE '%FEK%'

60 rows affected.

I've tried to find a FTS alternative:

SELECT

*

FROM

...

Hello,

Found it! It seems SSRS is responsible for this. The Transactions/sec on the ReportServer databases are showing the exact same line as the heartbeat.

Regards,

Peter