Can not get any search result using full text search in SQL Server 2005 Express.

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hi I am using SQL Server 2005 Express for full text search. I have
created catalouge and fultext index on the database and table. I
checked all the properties of the full text index using the queries.
select * from sys.fulltext_indexes

and everything seems to be fine.

But I am not getting any query results when I perform the following
query

select * from itemtags where contains(tags,'"clickz"')

Please someone help me!!!

.