WSS Full Text Indexing and SQL Server Failure and Resolution

I was having few issues around WSS site search in my production environment. It was not returning any search results. After looking at the issue, it was clear that the SQL Full-Text search component is unavailable to populate the catalog. Fallowing is a good detail article that I found that explain how to trouble shoot this issue.

WSS Full Text Indexing and SQL Server Failure and Resolution

KB Articles Links

PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel

How to manually reinstall the Microsoft Search service for an instance of SQL Server 2000