SQL Server 2000 Full-text Search (FTS) works specificly with columns defined with the TEXT datatype. While both T-SQL LIKE vs. FTS are fuctionally used to search text, the approch and the...

Yes... Checkout the following KB articles:

327217 "INF: Installing SQL Server 2000 Service Pack 3 Rebuilds All Full-Text Catalogs"

http://support.microsoft.com/default.aspx?scid=kb;en-us;327217

312410 "FIX: Full Text RANK Results May Vary After Catalog...

Q. What benefit does SQL Server give me?

A. SQL Server provides you all the benefits of a Relational Database Management System (RDBMS) that the Indexing Services (cisvc.exe) does not, such...

Hi,

Sorry, for the late reply... I've reviewed all past fulltext newsgroup replies where the poster have gotten this error and in all cases the only solution was to re-install the...

Interesting that you found this info about "Searching with SQL Server 2000" on a web page at "Administrator's Guide for Windows Sharepoint Services" and not on a Microsoft SQL Server...

You can use the following metadata Full Text Search (FTS) queries to obtain info from the FT Catalog. Try executing the following SQL code in your FT-enabled database:

-- Number of...

SQL Server 2000 Books Online (BOL) title "Full-text Search Recommendations, states relative to RANK that "...RANK values returned in the result set are relative to each other. Therefore, it is...

Yes, What is the <value> for the following registry key on the server where this problem exists?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<named_instance>\MSSQLServer

 FullTextDefaultPath=  <value>

Do you get the same error if you specify a specific...

Very soon, Frank...

I've been somewhat pre-ocuppied with work-related activities that pay the bills... However, I do plan to have SQLFTS.com up and running as soon as I can as I...

The key error is "80070002 - The system cannot find the file specified" and one of these KB articles should be helpful to you:

Q304282 PRB: Full Text Resource Fails to Come...

Why are you installing the Full-text Search components on your SQL Server 2000 machine in the first place? If you're using SQL Server 2000 Standard Edition & above, the FTS...

Greg is correct. SQL Server 2000 Full-text Search (FTS) can functionally successfully with the MSSQLServer service running under the system account (LocalSystem - your "local user"?) as well as under...

Searching text with Full-text Search (FTS) can be senstive to both the OS version (Win2K vs. Win2003 or WinXP) as well as to the actual text you are searching for,...

Yes, I believe that it is a Win NT4.0 Workstation, the emphis on Workstation that is a simalar OS version as Win XP Professional. On the latter, you need SQL...

Is this SQL Server 7.0 or SQL Server 2000 on NT 4.0 Workstation and what Edition of SQL Server? Could you post the output of SELECT @@version -- as this...