ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jj
Try executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default...b;en-us;317746
HTH
Francis
"jj" wrote:

> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>