July 9, 2007 at 1:56 am
Is it possible to maintain FT indexing with autoupdating of FT indices?
I tried many ways and it seems SQlexpress has restriction: you can full populate catalog but catalog cannot be autoupdated. Is it?
July 10, 2007 at 10:46 am
Express does not come with FULLTEXT but developers added it through code so Microsoft relented so I am not surprised it is not populating the catalogs automatically which means Microsoft just let developers use old technology for free. The reason is 2000 require you to populate the catalogs manually when I last used it a long while back.
Kind regards,
Gift Peddie
July 11, 2007 at 11:55 pm
Hi,
sqlexpress comes with FT without any notes about restrictions. But i cannot find how to do autoupdating.
Regards
July 12, 2007 at 9:03 am
Full Text was not working out of the box with Express then the developer in the link below provided the code solution so Microsoft added it with service packs but I think they added the 2000 version which is manual.
http://www.wherecanibuyit.co.uk/ASP/full-text-search.html
Kind regards,
Gift Peddie
July 16, 2007 at 10:56 am
July 16, 2007 at 10:59 am
Hi
I just clicked both links and it works so try again.
Kind regards,
Gift Peddie
July 16, 2007 at 11:05 am
Yes, now its working, thank you.
Its very strange: i use the same script for FT creating but all new items is not reflected in the FT catalog....
Regards,
Oleg.
July 16, 2007 at 11:17 am
Then I would say check the configuration Manager to make sure Fulltext Search is set to auto from Manual mine is auto by default but I am running the developer edtion. Hope this helps.
Kind regards,
Gift Peddie
July 17, 2007 at 4:07 am
Hi, thanx, its a difference between express and other editions of 2005.
In dev ed or enterprise ed no problem with automatic FT updating.
Regards,
Oleg.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply