Execution of a full-text operation failed. A clause of the query conta

[jadoger]

well,
I have done almost all the things but still getting this error while doing full text search
Execution of a full-text operation failed. A clause of the query contained only ignored words

What i have done is

1.removed every thing from all the Noise.* files in \FTDATA\SQLServer\Config,( i am using sql server 200 standard, language ENGLISH US)
2.Restarted SQL SERVER
3.rebuild/repopulated full text catalog, and even droped/deleted catalog and indexes.

but I am still getting this error
Execution of a full-text operation failed. A clause of the query contained only ignored words

I have no clue what else to do
any help much appriciated

jadoger

 

[SQLSister]

What was the query you ran?

Questions about posting. See faq183-874

 

[jadoger]

here is the query...

SET QUOTED_IDENTIFIER OFF
declare @vTemp as varchar(22)
declare @vTemp1 as varchar(60)
declare @vTemp2 as varchar(12)
set @vTemp2 = '" 4"'
--set @vTemp1 = '14 Marchmont Rd'
set @vTemp1 = 'SF6 9NU'
--ASSIGN ANY VALUE LIKE '.', '(' AND ERROR WILL OCCUR
set @vTemp = '.'
SELECT * From Temp
where
freetext(fullname,@vTemp)
and
freetext(Address,@vTemp1)
AND contains(zip , @vTemp2 )

Table:
ID ADDRESS ZIP FULLNAME InContact GENDER RID TITLE
1 14 Marc Rd SF6 9NU Mrs ban- Jackson 46 Male 1 Mr
2 14 Marc Road SF6 9NU ban - Jackson 42 Male NULL Mr
3 14 Marc Broadway SF6 9NU ban- Jackson 1 Male NULL Ms
4 14 March Rd SF6 9NU ban-jackson 3 Male NULL Miss
5 14 Map Park SU3 8PY M Rowden 1 Female NULL NULL
6 14 Map Park SP3 8XY N Bac Male NULL NULL
7 14 Map Drive SK2 5XJ V Na 2 Male NULL NULL
8 14 Map Wood NU0 0UN ban-jackson 1 Female NULL NULL