Hello everyone,
I'm having an issue querying some fields under Full Text Search. I have a stored procedure that receives 4 parameters. 3 of them query the database using LIKE operator, and they work very fine, but one of them queries 2 FTS columns using the CONTAINS operator.
Those 2 columns always return me the error 2. Does anyone here has any idea on why that could be happening? The error only happens when queried under an ASP.NET application. With query analyzer, it runs always under 2 seconds.
Thanks in advance for any help,
Marcelo