Yes... I've seen this before (many times) in the public fulltext newsgroup. You can either follow the procedures in the following KB article:

827449 "How to manually reinstall the Microsoft...

Hi Arron,

Yes, I post many of the replies (and answers) in the public fulltext newsgroup, and I also monitor and post in this fourm as well as others as "forums"...

Hi Aaron,

SQL Server Full Text Search (FTS) indexes the words (or really tokens) based upon the specific column's "Language for Word Breaker" or if you want to use the Neutral...

I too would agree, if you do not already have a clustered index on the Word column, you should create it. This assumes that most (if not all) of your...

Unfortunately, there is no workaround to this as it "by design" and necessary for the MSSearch service to access SQL Server tables. Option 2 is your best option, as you've...

You're welcome, JuanBob,

Actually, you are on the most current SP (SP4 = build 8.00.2039) and installed on Win2003 SP1. The latter is good to know becuase that means that your...

JuanBob,

Could you reply with the full output of -- SELECT @@version -- on the server where your FT-enabled inventory exists? As this is most helpful information in understanding your enviroment...

The primary error is "800700e9 - No process is on the other end of the pipe.". This error is often caused by removing or altering the SQL Server login BUILTIN\Administrators...

Well, I am the expert on SQL Server Full-text Search (FTS) as I have worked with it while at Microsoft since its inclusion in SQL Server 7.0 Beta3 in 1998....

Q. My question is do i need to restart the service..

A. First of all, are you refering to the restarting the SQL Server (MSSQLServer) service or the Microsoft Search...

Sure... Single digit numbers (0 - 9) are included by default in all of the language specific noise word files. What you need to do is to remove these single...

You can use several methods to insert files (pdf and other file types) to be stored in SQL Server table that includes a column defined with the IMAGE data type. You can...

You're welcome, Robert,

There may be entries in the system table sysfulltextcatalogs for the deleted FT Catalog &/or there may be registry keys for the FT Catalog folder name (e.g., SQL00050005...

Robert,

First of all, removing the Full Text Catalog will not shrink the size of your 50 Gb Db because the FT Catalog folder and files are maintained outside of the...

Noel,

Q. So following that logic then, could I set the Microsoft Search Service to run under the SQL Service account?

A. While logical this may seem correct, in practical terms this...