I have created a catalog and fulltext index for my table as :
create fulltext catalog testsearch
CREATE FULLTEXT INDEX ON test_master
(name)
KEY INDEX PK_test_master
ON testsearch
But when I try to retrieve values as
select * from test_master where contains(name, 'product')
The query just returns me the columns of the table 'test_master' but no rows are populated.. I'm not getting any error either.. i have tried populating my index again and i am sure that i have a value 'product' in column 'name'.. plz help me