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

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

Post by dinesh.shr » Tue, 30 Oct 2007 19:42:11


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!!!