Hi, All:

I got a issue about full index, any body can help me on this? 

1. set up full text index

CREATE FULLTEXT INDEX ON dbo.Companies(my table name) ( CompanyName(colum of my table) Language 0X0 ) KEY INDEX IX_Companies_CompanyAlias ON QuestionsDB WITH CHANGE_TRACKING AUTO GO

1. Using CONTAINS to find the matched rows

   SELECT CompanyId, CompanyName FROM dbo.Companies WHERE CONTAINS(CompanyName,'Micro')

2. All is going well. just just just return empty resultset. And I am sure there is company with CompanyName "Microsoft" in Table Company

Much appreciated if anybody does me a favor on this.