Fog Creek Software
Discussion Board

full-text indexed

I am receiving this error when I run a search through FogBugz:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use a CONTAINS or FREETEXT predicate on table 'BugEvent' because it is not full-text indexed.

/fog/summary.asp, line 954

I am running SQL 7.0 and I am not able to set the database to "Full-Text Indexing".  That option is greyed out in the Tools menu.  Can an NT Workstation have a full-text indexed search? Do I need an additional Microsoft Search service?  What can I do to resolve this problem?


Darren Haas
Monday, August 5, 2002

This is an installation option and hence for some unknown goofy Microsoft reason, I believe if you don't check it at install time, the only fix is to reinstall and make sure its checked.

Michael H. Pryor
Monday, August 5, 2002

I finally found a Microsoft Whitepaper on full-text indexed searches and you cannot setup the Service needed on a NT Workstation on a NT Server.  I guess I will have to setup a server.

Darren Haas
Tuesday, August 6, 2002

*  Recent Topics

*  Fog Creek Home