I just created a full text catalog :
- Enable full text (right click on db => file => enable ful text indexing)
- Create catalog (Storage => Fulle text Catalog => New Catalog => "FTCatalog" => OK)
- Add column to catalog (right click on catalog => properties => table/views add table/columns , automatic => ok)
The table has 270k lines, I created the catalog this morning and still it has 0 Item Count and the populate status is 1.
The logs in […]\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLFT0000800007.LOG doesn't show anything more than (i tried to recreate it 10 min ago)
2014-06-30 16:32:03.93 spid23s Informational: Full-text Full
population initialized for table or indexed view '[XXX].[dbo].[XXX]'
(table or indexed view ID '1771153355', database ID '8'). Population
sub-tasks: 4.
All SPs are installed.
I tried with some smaller table, it's the same.
The service "SQL Server FullText Search" is running.
Nothing on the EventViewer.
Any idea ?
UPDATE
In Sql Server Log I have these two thing :
Changing the status to PAUSE for full-text catalog "XXX" (7) in database "XXX" (8). This is an informational message only. No user action is required.
Changing the status to PAUSE for full-text catalog "XXX" (7) in database "XXX" (8). This is an informational message only. No user action is required.
Best Answer
You might try scripting it out to see if you get a different behaviour. This simple example runs in under a minute on my local SQL 2005 instance:
What happens when you issue an explicit start for the index population, eg
Run these summary functions