Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Odd errors

Author  Topic 

CodeDreamer68
Starting Member

9 Posts

Posted - 2010-08-04 : 13:25:06
Hi all,

I am getting this error...

Syntax error near '<word>' in the full-text search condition...

The error is correct, I mean it makes sense that the full text query is invalid. I know how to write a valid full text query.

However, what is odd is that this is occuring when I execute a stored procedure that DOES NOT HAVE ANY FULL TEXT predicates. The query called, does access the same table that is indexed, however the query does not utilize full text.

I'm frustrated and have no idea where this error is coming from.

Of note: This is a classic ASP application utilizing ADODB Command object to set up and execute the stored procedure.

Is it possible SQL has cached something? Anyone have any ideas?

CodeDreamer68
Starting Member

9 Posts

Posted - 2010-08-04 : 15:21:17
Never mind, I figured it out.
Go to Top of Page
   

- Advertisement -