Trouble with full text query

[rtgordon]

I developed a database table on my desktop XP Pro Sql server 2000, and populated it there. I built a full text index and I can run and get values with this query

SELECT Level1Desc,	Level1,
			Level2Desc,	Level2,
			Level3Desc,	Level3,
			Level4Desc,	Level4,
			Level5Desc,	Level5,
			Level6Desc,	Level6,
			COUNT(*) as Total FROM SearchTable 
		WHERE CONTAINS(SearchText, ' "*fluke*" AND "*187*" ') 
		GROUP BY 	Level1Desc,	Level1,
				Level2Desc,	Level2,
				Level3Desc,	Level3,
				Level4Desc,	Level4,
				Level5Desc,	Level5,
				Level6Desc,	Level6

		ORDER BY 	Level1Desc,	Level2Desc,
				Level3Desc,	Level4Desc,
				Level5Desc,	Level6Desc

I get data back as I expect and everything works fine.

I copy the table over to the server, rebuild the index, run the same query on the same data and get nothing back. I am really confused.

Any ideas about where to start looking for the solution?

Thanks,
Gordon

 

[SQLSister]

First are you absolutely sure that full text search service has been started? Are you sure the index was finished populating at the time you ran the query?

Questions about posting. See faq183-874

 

[rtgordon]

Yes, both are true. It runs fine and I get results for both if I run each separately:

WHERE CONTAINS(SearchText, ' "*fluke*" ')

WHERE CONTAINS(SearchText, ' "*187*" ')

but I don't get anything if I try to combine them with AND... This is only on the server box. I know there is a part in the searchtext field called 'fluke-187'.

 

[rtgordon]

Anyone???

 

[rtgordon]

Is there any configuration for how FTS handles noise words, word concatenation, etc that might be causing this problem?

Thanks,
Gordon