SYMPTOMS
If you use the entire filename, and not just the extension, of a file to specify the type of document stored in a full-text enabled column, the data returned when SQL Server queries the full-text index, may not be consistent with the data actually stored in the column. The following code shows how you can use the filename to specify the type of document stored:
exec sp_fulltext_column 'BlobTestTbl', 'Document', 'add', NULL, 'Filename'
In the preceding code, the fifth argument
Filename is the name of the column that stores the type of document. In this case, the entire filename is stored in the
Filename column.
According to SQL Server Books Online, this fifth argument must point to a column that stores the extension of the document stored in the full-text enabled column. For more information, see the "Filtering Supported File Types" topic in SQL Server Books Online.
In addition, the following errors may appear in the Microsoft Windows NT Application Log if you attempt to enable the column for full-text indexing:
Event Type: Information
Event Source: SQLFTHNDLR
Event Category: None
Event ID: 2001
Description:
One or more documents stored in image columns with extension 'document_name' did not get full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for indexing, and therefore this failure will not be reflected in the end of crawl summary statistics.
Event Type: Information
Event Source: SQLFTHNDLR
Event Category: None
Event ID: 2002
Description:
Full-text indexing a document stored in an image column failed with error '0x8007007b'.
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack