all groups > sql server full text search > october 2007 >
You're in the

sql server full text search

group:

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. dinesh.shrinath NO[at]SPAM gmail.com
10/29/2007 3:42:11 AM
sql server full text search:
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!!!
AddThis Social Bookmark Button