The solution... Fox my case anyway. Create a batch file called fixsql.bat with this as the contents:-
@ECHO OFF CLS regsvr32 %windir%\System32\athprxy.dll /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\Common\mssitlb.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\ftsqlpar.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssadmin.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\msscntrs.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssmmcsi.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssmsg.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssmulpi.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssph.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\mssrch.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\msstools.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\nlhtml.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\objcreat.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\offfilt.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\propdefs.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\srchadm.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\srchidx.dll" /s regsvr32 "%programFiles%\COMMON~1\System\MSSearch\bin\tquery.dll" /s pause This was adapted from a posting ON DBFORUMS.COM Restart "Microsoft Search" service after running it and voila - It now indexes like a charm. I think this is definitely a problem with MS Clusters only. Martin http://www.beetrootstreet.com -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 02:18 To: CF-Talk Subject: RE: SQL Server 2000 Full-text search issues Martin, That's the weird thing with ours. I assumed the same thing that it was the install. So, we scheduled down time for the production box, uninstalled SQL 2000 and rebooted. Then, reinstalled SQL 2000, rebooted, installed SP4, rebooted and got the same results. John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220108 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
