Just started working with full text indexing in SQL Server 2000, have 18 tables that are going to be updated several times a day via an admin interface that uploads CSV files and inserts them via a DTS pkg.
My question is in refreshing the index. Obviously, I can schedule the repopulation via Enterprise Mgr to happen at sya, midnight every night, but I'm hoping to come up with a solution where after the CSV upload process ends, another process fires off that will do the reindex. Anyone have any idea on how I could do this? -- Ray Champagne Web Developer, Dolan Media Company 612.215.6497 :: 612.718.8852 (m) ray.champagne [at] dolanmedia [dot] com GTalk: raychampagne ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:236558 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5