John
May 24, 2001Yep, I'm back.
I've got a development server running SQL Server 7. For some reason, the full-text indexes absolutely refuse to populate. They claim they're repopulating, and they claim to successfully repopulate, but they're coming out blank.
We need our full text indexes, because we need to test (on said development server) some freetext-based queries before going live. (The live server doesn't seem to have this problem, but SQL Server was installed and configured with the same options on both.)
Things I've checked:
* Microsoft Search Agent is running
* The full-text indexes have been rebuilt (several times)
* This is occurring to all databases on this server
* SQLAgent is running
* MSSQLServer service is running
* System and administrator accounts have full control over FTDATA and WinntTempGHTRSVC directories.
Microsoft's Knowledge Base and online troubleshooter were of no help. (I went through every step of the online troubleshooter except messing with the registry to increase the search index size. I can't bring myself to do this on a piddly little 53-meg database -- it shouldn't be needed, especially since only a few columns of one table are being indexed!)
Anyone have any ideas?
Thanks in advance!