The Question and Answer Board

[Bob Zumbrunnen]

Wow!

My bad on two counts.

First, I had disabled change tracking on the regular message table so the machine wouldn't get swamped building indexes for two tables. That's why the search at the top of the screen wasn't updating.

Second, I re-enabled it and the server freaked!!! Finally had to reboot it.

We've got serious search-related issues going on here. It also takes over half an hour to copy just 8000 new messages from the message table to the new search table (at night) and takes several hours to add those 8000 messages to the full-text catalog.

Serious problem happening. Not a clue what yet. MSSearch, in typical MSFT fashion, tries to be too helpful by keeping the hood welded shut.