Art,

You could try this:

SELECT ticket_id,ticketnote_id, ticketnote_byname, Ticketnote_text FROM DMS_TICKETNOTES

WHERE Ticketnote_text LIKE '%998877%'

It's just a simple query that should return the values you are looking for from any row that...

Art,

You could insert a wildcard character % into the query like such:

SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

WHERE CONTAINS (ticketnote_text, ' "*%0099887766*" ')

Order by Ticketnote_id

This should return what you are...

Looks like it was the Performance Monitor.

When we removed

SQL Server Buffer Manager Object

-Buffer Cache Hit Ratio

SQL Server Locks Object

-Average Wait Time

from the counter list, the problem seems to be...