Event Id2002
SourceSQLFTHNDLR
DescriptionFull-text indexing a document stored in an image column failed with error 0x8007007b.
Event InformationAccording to Microsoft:
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. To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. To work around this problem, make sure that only the extension is stored in the column that specifies the type of document stored in a full-text index.
Reference LinksFIX: Full-Text Query Does Not Return the Expected Result Set


  Did this information help you to resolve the problem?
  Yes: My problem was resolved.
  No: The information was not helpful / Partially helpful.
  Comments:

Captcha  Refresh