sql server full text search: 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

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


[quoted text, click to view]