"Mark Holahan" <mark.holahan@unifiedllc.com> wrote in message
news:Ogx2wObHFHA.2860@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I've enabled a full-text index on a table having 77 thousand records on a
> varchar(50) column. And yet when I when I populate the catalog:
> exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
> I get an item count,
> SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
> of 0.
>
> This column has data 95% of the time. What am I missing?
>
> Thank you.
> --
> --
> Mark Holahan
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:ek2TowbHFHA.3880@TK2MSFTNGP10.phx.gbl...
> Check the event log and the gatherer logs for messages:
>
> It is likely you are running into one of the errors in these kb articles
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295034
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295772
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Mark Holahan" <mark.holahan@unifiedllc.com> wrote in message
> news:Ogx2wObHFHA.2860@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> I've enabled a full-text index on a table having 77 thousand records on
>> a
>> varchar(50) column. And yet when I when I populate the catalog:
>> exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
>> I get an item count,
>> SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
>> of 0.
>>
>> This column has data 95% of the time. What am I missing?
>>
>> Thank you.
>> --
>> --
>> Mark Holahan
>>
>>
>
>

"Jeffrey Wang" <cjeffwang@gmail.com> wrote in message
news:ug43i2TIFHA.2924@TK2MSFTNGP15.phx.gbl...
> Hi Hilary,
>
> I have had a similar problem with the Full-text Catalog Item Count of 0,
> after I enable some Full-text Indexing from 4 tables. I can view the
> table names on the Full-text Catalog, but when double-clicked the
> Catalog, the propereties page showed an Item Count of 0.
>
> Because we are developing a back-end database for a SharePoint Services
> server, based on the information from the SharePoint Administration
> guide, we needed to use Domain Account, instead of the local System
> account, after we saw the Item Count of 0 for our first try.
>
> The big question is after we set up the domain account, the Item Count
> was still zero.
>
> Is something wrong with the Full-text Search configuration, or on the
> SharePoint Service server?
>
> Thanks,
> Jeffrey
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!