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
a source to share