SQL Server Full-Text index not self populating when copying between two tables.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nguyen Tran (wintran_at_gmail.com)
Date: 09/13/04 

Date: 13 Sep 2004 15:35:49 -0700

Hey I have a wierd SQL Server 2000 full-text index problem when
copying between two image tables.

I'm using Access XP as my front end and SQL Sever 2000 (with SP3a
install) as my backend. I'm trying to parse and search resumes using
the SQL Server 2000. I'm using a staging table to proof new resumes
coming in so I can delete duplicates before they enter the system. I
store the whole resume in a staging table before posting it to a
full-text index table.

The problem I'm running into is when I post the data from the staging
table into my permanent document table, the fully text index is not
populating. But when I upload the data using MS Access directly into
the document table, the full text index is being populate. I have the
full text index tracking turned on, too. Even after I rebuild the
full text index, the documents I copied over from thst staging table
still does not show up.

Do you have any idea what's wrong?

-Nguyen Tran

Relevant Pages

  • SQL Server Full-Text index not self populating when copying between two tables.
    ... Hey I have a wierd SQL Server 2000 full-text index problem when ... the SQL Server 2000. ... I'm using a staging table to proof new resumes ... populating. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Update Table with DTS
    ... You can use the DDQ here by all means but be aware that this operates on ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Do you mean staging table is a temporary table that I ... >>> I am new to DTS and don't know Data Driven Query at all. ...
    (microsoft.public.sqlserver.dts)
  • Re: Update Performance
    ... I know the "counter" seems like a generic stat, ... > Pro SQL Server 2000 Database Design - ... >> Add a row to tblStats with the count from the staging table. ... >>> Louis Davidson - drsql@hotmail.com ...
    (microsoft.public.sqlserver.programming)
  • Re: Import CSV and update existing conflicting existing record(s)
    ... "staging" table first. ... I compare and load it to the destination table. ... In DTS (SQL Server 2000) this would be done using a data pump task to ... and potentially fix data that fails the validation steps. ...
    (microsoft.public.sqlserver.dts)
  • Re: Need help with data conversion
    ... If my source is a text file I *ALWAYS* use a staging table before loading ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> It may be that you need an active Script transform, ...
    (microsoft.public.sqlserver.dts)