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. I have 2 production servers. 1 production CF Server (Windows 2003 Server, CFMX 6.1) and 1 Production SQL Server (Windows 2000 Server, SQL Server 2000 SP4). I have copied the database from dev to production and then run the same query against it and it only returns 2 rows. I have rebuilt the catalog and repopulated the full-text index multiple times. I can even take that database that only returns 2 records and copy it down to the dev server and then it returns 31 records. I have attempted to uninstall and reinstall SQL Server 2000 on the production box and then installing SP4 but have not had any change. If I run a query on just one out of the five columns that are full-text indexed and do "where column like '%value%' " with "value" being the same I'm using in the full-text index, I actual get like 15 rows returned. I'm at my wit's end on this one and don't know where to turn. If anyone here has any ideas, please let me know. If you don't think this is pertinent to this list, please recommend a good SQL list or board that I could check out. Thanks! John Burns
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219767 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
