Viewing 15 posts - 76 through 90 (of 102 total)
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...
January 19, 2005 at 9:58 pm
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...
January 13, 2005 at 12:54 am
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...
January 12, 2005 at 7:38 am
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...
January 9, 2005 at 11:16 pm
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...
January 6, 2005 at 9:23 am
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...
January 5, 2005 at 10:29 pm
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...
January 4, 2005 at 1:16 am
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...
December 30, 2004 at 12:41 am
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...
December 13, 2004 at 12:14 am
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...
December 10, 2004 at 1:20 am
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...
October 25, 2004 at 11:05 pm
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...
September 24, 2004 at 1:19 am
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,...
September 15, 2004 at 1:26 pm
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...
September 13, 2004 at 10:35 am
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...
September 10, 2004 at 11:11 am
Viewing 15 posts - 76 through 90 (of 102 total)