Martin - I've actually found some answers dealing with the issue you're talking about. I'll have to look again and I'll send you the link. Everything I've found seemed to fall into the cluster situation and returned zero results. That's the screwy thing about mine is that it always returns 2. If memory serves correctly, a lot of the issues dealing with the cluster and the issue you're describing had to do with upgrading from SQL 7 to SQL 2000. Did you do that by chance? Let me know. John Burns
________________________________ From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Fri 9/30/2005 11:41 AM To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues I too get this on my 2003 cluster. I restored the database as a backup from my dev box (which it works on) and do a full rebuild - It takes but a second to say its complete and then gives me absolutely no results. If I find a solution I'll post it here. IF! Martin Parry http://www.beetrootstreet.com -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 30 September 2005 16:22 To: CF-Talk Subject: SOT: SQL Server 2000 Full-text search issues I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX 6.1) on which I have a database that has full-text enabled on a table. When I run a query against the full-text index, it returns 31 rows. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219851 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
