SQL SERVER FULL-TEXT INDEX, CONTAINS return empty
- by max
Hi, All:
I got a issue about full index, any body can help me on this?
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
Using CONTAINS to find the matched rows
SELECT CompanyId, CompanyName
FROM dbo.Companies
WHERE CONTAINS(CompanyName,'Micro')
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.
