You need to rebuild the full-text catalog when you restore the db Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development
We endorse PayPal, accept payments online now! > -----Original Message----- > From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: Saturday, 1 October 2005 11:25 PM > To: CF-Talk > Subject: Re: SQL Server 2000 Full-text search issues > > > Hi, > Full-text search on SQL Server 2K gave me huge problems. Not > only was the code to conduct a full-text search cumbersome, > but the user had to learn how to define searches in ways that > were not really fair to the user. That is why I decided to > turn to another appliance for full-text search structured > databases. At first I tried using the Verity search already > packaged with CFMX. However I soon ran into scaling issues in > terms of the number of records that Verity will store. Since > one of my dbs stores more than 100K records, that alone would > take up the limits of Verity's licence. Buying an unlimited > (or whatever) licence for Verity was a bazillion dollars. > Similar problems with buying a Google search appliance. We > decided to go with Lucene from the Jakarta project which is a > simply beautiful product. And it is free. Of course you have > to learn Java, but the Lucene email lists are extremely > helpful. Besides Aaron Johnson has some code over at ( > http://cephas.net/blog/2003/12/06/indexing_database_content_wi > th_lucene_coldfusion.html) > that even talks about CF and Lucene. > > I know this doesn't solve your current problem, but I ran > into issues with SQL server like you did and some of them > were having our customers (and I, to some extent) tear their hair out. > > If you need some help with CF and Lucene, I can list some > resources or email me offlist. > > George > > > On 9/30/05, Martin Parry <[EMAIL PROTECTED]> wrote: > > > > 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. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219829 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