Hi Zac,

Have you tried using the WEIGHT parameter on two columns? For example, using the Northwest database table Employees and two FT-enable columns (Notes and Title):

SELECT e.LastName, e.FirstName, e.Title, e.Notes...

Can I assume that you're using SQL Server 2000? When you can reply back with the @@version output... If you are using SQL Server 2000, I'd highly recommned that you...

When you say the "Scheduled Tasks application" are you referring to taskmgr.exe or to the "microsoft search" (mssearch.exe)? If the former, then your statement is incorrect as the taskmgr.exe does...

Jeremy,

This is somewhat a FAQ on the public fulltext newsgroup, and for SQL Server 7.0 or 2000, the version of SQL Server is less useful than the OS platform you have...

This is a bug related to moving / restoring FT-enabled databases to another

server where the drive letter for the FT Catalogs is different than the

orgianal server. You can work around this...

Gaine,

Have you or anyone else changed the MSSQLServer services startup account &/or password via Win2K's Component services applet? If so, this could account for the FT Catalog's not populating. You...

Ok. Have you modified it in any way? Secondly, I'm assuming that the MSSearch service is running the "system account" (LocalSystem). Correct?

Additionally, can you confirm that no one has...

Yes, I do...

Have you or anyone else removed or altered the BUILTIN\Administrators login? If so, then you need to re-add it with all of the default settings, including using the...

Yes, that is correct. While SQL Server 2000 or SQL server 7.0 can run under the "system account" (LocalSystem) or a DOMAIN\Account, the "Microsoft Search" (mssearch.exe) service should always run...

Just Full-text enabling a database should take only seconds as the only thing that sp_fulltext_database 'enable' does is set some values in the a few system tables. So, something else...

In context of what the poster is trying to do, yes @variables DO work with CONTAINSTABLE or FREETEXTTABLE, for example:

declare @SearchStr varchar(8000)

SET @SearchStr = '"green" or "white"'

SELECT FT_TBL.au_lname, FT_TBL.au_fname, KEY_TBL.RANK

 ...

Actually, using a @variable does work (from BOL title "CONTAINS")

H. Use CONTAINS with variables

This example uses a variable instead of a specific search term.

USE pubs
GO
DECLARE @SearchWord varchar(30)
SET @SearchWord...

Posting this after this issue had been resolved as others may read this in the future and gain from additional info...

First of all, troubleshooting SQL Server (7.0 or 2000) Full-text...

You're welcome, Mark,

Sorry, I missed you're reference for a "partial word search". Thanks, for the further difintion. However, SQL Server Full-Text Search (FTS) does not provide the type of pattern...

Change FREETEXTTABLE(IN_PROFIL, *, @SearchText) to CONTAINSTABLE(IN_PROFIL, *, @SearchText)  as wildcards are ignored with FREETEXTABLE. Note, Boolean (AND / OR), proximity (NEAR), wildcard ("*" asterisk) operators are ignored in a FREETEXT or...