SQL Server Full-Text Access Search Returns No Results

I have SQL Server 2005 Express Edition with Advanced Services. I included FullText and created a directory like this:

create FullText catalog MyDatabase_FT in path 'mypath' as default

      

Then I created a FullText index like this:

create FullText index on Cell (CellName) key index PK_Cell
    with CHANGE_TRACKING AUTO

      

I have completed the following requests:

1) select count(*) from Cell where contains (CellName, 'CU*')
2) select count(*) from Cell where CellName like 'CU%'

      

And got the following results:

1) 0
2) 24

I understand that it can take a while to populate the FullText indexes. However, despite a lot of time (12 hours), I still don't get any results. Then I investigated further using the ObjectPropertyEx () function and did the following:

declare @id int
select @id = id FROM sys.sysobjects where [Name] = 'Cell'
select 'TableFullTextBackgroundUpdateIndexOn' as 'Property', objectpropertyex(@id, 'TableFullTextBackgroundUpdateIndexOn') as 'Value'
union select 'TableFullTextChangeTrackingOn', objectpropertyex(@id, 'TableFullTextChangeTrackingOn')
union select 'TableFulltextDocsProcessed', objectpropertyex(@id, 'TableFulltextDocsProcessed') 
union select 'TableFulltextFailCount', objectpropertyex(@id, 'TableFulltextFailCount') 
union select 'TableFulltextItemCount', objectpropertyex(@id, 'TableFulltextItemCount') 
union select 'TableFulltextKeyColumn', objectpropertyex(@id, 'TableFulltextKeyColumn') 
union select 'TableFulltextPendingChanges', objectpropertyex(@id, 'TableFulltextPendingChanges') 
union select 'TableHasActiveFulltextIndex', objectpropertyex(@id, 'TableHasActiveFulltextIndex') 

      

This gave the following results:

TableFullTextBackgroundUpdateIndexOn 1
TableFullTextChangeTrackingOn 1
TableFulltextDocsProcessed 11024
TableFulltextFailCount 0
TableFulltextItemCount 4038
TableFulltextKeyColumn 1
TableFulltextPendingChanges 0
TableHasAxFulltext

Then I tried to make a new complete index population like this:

alter fulltext index on Cell start full population

      

And I get the following warning:

Warning: Request to start a full-text index population on table or indexed view 'Cell' is ignored because a population is currently active for this table or indexed view.

I tried the update population like this:

alter fulltext index on Cell start update population

      

This returns: "Command completed successfully". However, I still don't get any results in the FullText search.

What am I missing? What do I need to do to find a FullText job?

Thanks, Elan

+2


a source to share


1 answer


Well it all came down to the formatting of the search text.

This is not true:

select count(*) from Cell where contains (CellName, 'CU*')

      



It was correct:

select count(*) from Cell where contains (CellName, '"CU*"')

      

Everything works fine!

+4


a source







All Articles