You can use the sp_fulltext_catalog http://msdn2.microsoft.com/en-us/library/aa933400(SQL.80).aspx
> -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 13, 2007 12:35 PM > To: CF-Community > Subject: programmatically start full text population > > 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 Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:236563 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
