populating a catalog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shank - 24 Jun 2004 22:53 GMT

I created a catalog and indexed 3 tables successfully, into that catalog.
The catalog is 4MB in size, so there must be something in there.
When I query the catalog with the following query, I get an empty column
with (No column name) for a heading.
SELECT FullTextCatalogProperty ('MyCatalog', 'm_Specs')

When I use sp_help_fulltext_tables, I successfully get a list of columns in
the catalog.

Where am I going wrong? Why can't I get any results in my column m_Specs?
I couldn't get results for any other column either.

thanks

Reply to this Message

John Kane - 25 Jun 2004 04:51 GMT

shank,
While the physical catalog is 4Mb in size, what does SQL Server (version ?)
report via the Enterprise Manager or the following SQL code?

SELECT FullTextCatalogProperty('<Your_FT_Catalog_Name>', 'itemcount')
SELECT FullTextCatalogProperty('<Your_FT_Catalog_Name>', 'uniquekeycount')
SELECT FullTextCatalogProperty('<Your_FT_Catalog_Name>', 'indexsize')

Most likely the FT Catalog was not successfully populated because of a
change in the MSSQLServer service account &/or password via Win2K's
Component Services or missing BUILTIN\Administrators login, see KB articles

277549 (Q277549) "PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through Control Panel"
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q277549

317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate
Catalogs"
http://support.microsoft.com/default.aspx?scid=KB;en-us;q317746

Regards,
John

> I created a catalog and indexed 3 tables successfully, into that catalog.
> The catalog is 4MB in size, so there must be something in there.
[quoted text clipped - 9 lines]
>
> thanks

Reply to this Message