Today one of my colleagues was experiencing some problem in the Microsoft Office SharePoint Server 2007 test environment. He started a crawling job last Friday and the job was still running this morning. He found a post with a solution for this problem. The title is “MOSS 2007 crawl never ends”. Click here to see the post.
The solution was to truncate some tables from the “shared_services_ search” database. The post also referred to http://support.microsoft.com/kb/930887/en-us . We solved the problem by truncating the following tables on the “shared_services_ search” database:
TABLES TO BE TRUNCATED (not deleted!!!):
(Exclude the MSSCrawlHistory table, if you try to truncate it, it will give you a FOREIGN KEY constraint).
You can use this script:
I hope this post will help you.