Full text indexing scheduler SQL Options

Hi all,

I'm hosting a site on DiscountASP and since I have full text enabled
I
need to schedule the population. However, they don't allow using SQL
Enterprise Manager and said I have to use SQL to do it. I'm really
having a hard time finding a sample code. Can someone please show me
an example of doing this? Let's say my database is called
'DatabaseA',
my table is call 'TableA' and I have full text enabled on two columns
'ColA' and 'ColB'.


Thank you
Maz

.

Relevant Pages

  • Re: Scheduling DTS Packages on 64-bit SQL Server
    ... My understanding is that DTS components are not available for 64-bit SQL ... > I found the following comment on Microsoft's website in regards to scheduling> a DTS package on a 64-bit SQL Server installation. ... do I need> to buy a 32-bit copy of SQL Server to store my packages on to be able to> schedule them? ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • SQL error
    ... I am attempting to permit the user to select 1 of 3 options in the display of database records. ... OptSchedule(0) is titled: ... The SQL statement worked before I included the sSchedule variable also. ... strSQL = "SELECT LastName, FirstName, ClientID, " ...
    (comp.lang.basic.visual.misc)
  • Re: ReportIoError 2 - any ideas?
    ... job - then modify the schedule as required. ... using DBCC SHRINKFILE to reduce the ldf file size. ... Rerunning the backups through Enterprise Manager. ... My colleagues know even less about SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: DTS Job fails when scheduled as Job (NOT a 269074 issue!)
    ... Agent does not support applications that have a UI. ... Try setting the SQL ... Agent service to allow interaction with the desktop. ... > If I try to schedule it, ...
    (microsoft.public.sqlserver.dts)