No more indexing on text

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I store text files into an SQL Express DB, in a varbinary field.

I have change the naming of some columns in my indexed DB, and I have
changed the indexed column: now, I have two varbinary(max) columns in my
table, one is indexed but not the other. All my files are text.

It appears that none of my files are indexed.Here is what I see in the logs:
2007-02-09 14:38:02.74 spid21s Informational: Full-text Full population
initialized for table or indexed view '[IndexingDB].[dbo].[Files]' (table or
indexed view ID '37575172', database ID '7'). Population sub-tasks: 1.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was found
during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0C. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was found
during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0D. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was found
during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0E. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Informational: Full-text Full population
completed for table or indexed view '[IndexingDB].[dbo].[Files]' (table or
indexed view ID '37575172', database ID '7'). Number of documents processed:
3. Number of documents failed: 0. Number of documents need retry: 0.
2007-02-09 14:38:15.46 spid21s Changing the status to MERGE for
full-text catalog "CmpArchivorCat" (41) in database "IndexingDB" (7). This
is an informational message only. No user action is required.
2007-02-09 14:38:15.47 spid24s Informational: Full-text Auto population
initialized for table or indexed view '[IndexingDB].[dbo].[Files]' (table or
indexed view ID '37575172', database ID '7'). Population sub-tasks: 1.

Here is the stored procedure I used to re-initialize my indexing:
exec sp_fulltext_table 'Files', 'drop'

drop index ui_ftindex on dbo.Files

DROP FULLTEXT CATALOG CmpArchivorCat

exec sp_fulltext_catalog 'CmpArchivorCat', 'create'

CREATE UNIQUE INDEX ui_ftindex ON dbo.Files(file_pk)

CREATE FULLTEXT INDEX ON Files
(file_text TYPE COLUMN std_indexing_type
LANGUAGE 0x0)
KEY INDEX ui_ftindex
ON CmpArchivorCat
WITH
CHANGE_TRACKING AUTO

exec sp_fulltext_service 'load_os_resources', 1;

exec sp_fulltext_service 'verify_signature', 0;

exec sp_fulltext_catalog 'CmpArchivorCat', 'start_full'

I was able to index files from all types in the same DB, but since I've done
my few changes, I can't get anything to work again. I have tried with both
text/plain and text/html in my file type column.

Please help!


.

Relevant Pages

  • Re: No more indexing on text
    ... I store text files into an SQL Express DB, in a varbinary field. ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... with both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: No more indexing on text
    ... Looking for a SQL Server replication book? ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)