Error 7645 querying FTS - not all servers

Question

Hello everyone,

I'm having an issue querying a FTS enabled database. When executing procedure against servers A and B, everything works fine, but servers C and D keep returning me an 7645 error. The query has 4 parameters, and the 1st one is the FTS field. It doesn't matter if I pass a NULL or ''.

What should I look for? What could be doing one server work and the other one not?

Thanks in advance.

---

Marcelo
http://www.eopreco.com.br - Price Comparison. Need the lowest price? We find it for you.

Answer 1

Hi Marcelo,

This suggest Null or empty full-text predicate. Check out this thread that contains the resoulution to this error. 

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

Thanks Basit. unfortunately, sp_executesql is not an option on my company :(

---

Marcelo
http://www.eopreco.com.br - Price Comparison. Need the lowest price? We find it for you.