all groups > sql server full text search > march 2004 >
You're in the

sql server full text search

group:

FullText catalog item count is 0


FullText catalog item count is 0 Yiaz
3/23/2004 9:16:06 AM
sql server full text search:
I've created a catalog against a fairly large table (around 900 rows) and selected Start full population from the catalogs context menu. A message appears saying it started populating successfully. However 24 hours later the Item count is still 0 and catalog size 1MB. I've tried restarting the FullText search support service via enterprise manager but no difference. All my simple contain queries return no rows

any ideas? sure im missing something simple

Re: FullText catalog item count is 0 Hilary Cotter
3/24/2004 12:47:35 PM
are there any messages in the event log for MSSearch or mssci?

Chances are that you have changed your SQL Server service account through
control panel and not through EM.

have a look at this link for info on how to correct it,

http://support.microsoft.com/default.aspx?scid=kb;en-us;295051
[quoted text, click to view]
selected Start full population from the catalogs context menu. A message
appears saying it started populating successfully. However 24 hours later
the Item count is still 0 and catalog size 1MB. I've tried restarting the
FullText search support service via enterprise manager but no difference.
All my simple contain queries return no rows.
[quoted text, click to view]

AddThis Social Bookmark Button