HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Property PopulationStatus is not available for FullTextCatalog... How to fix?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fixpopulationstatusavailablepropertyfulltextcatalogforhownot

Problem

I've created a new catalog (case insensitive, make default catalog), when I try to right click > properties to add tables I get this error:


Property PopulationStatus is not available for FullTextCatalog '[Search]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Executing this code I found I get NULL

SELECT FULLTEXTCATALOGPROPERTY('Search', 'Populatestatus')


When I right click on tables the Full-text index is grayed out...

What am I missing? How can I fix this?

Solution

I found out that even if it is not installed it is still available on SQL Server Management Studio and you can create the indexes. It shouldn't allow...

Then I found this: SQL Server 2008 R2 Express - Installation Options, to allow FTS I need the 800MB version...

To check the status of FTS I found these queries:

SELECT
    FULLTEXTCATALOGPROPERTY(cat.name,'ItemCount'),
    FULLTEXTCATALOGPROPERTY(cat.name,'MergeStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateCompletionAge'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'ImportStatus')
FROM sys.fulltext_catalogs AS cat

SELECT fulltextserviceproperty('IsFulltextInstalled')

Code Snippets

SELECT
    FULLTEXTCATALOGPROPERTY(cat.name,'ItemCount'),
    FULLTEXTCATALOGPROPERTY(cat.name,'MergeStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateCompletionAge'),
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus'),
    FULLTEXTCATALOGPROPERTY(cat.name,'ImportStatus')
FROM sys.fulltext_catalogs AS cat

SELECT fulltextserviceproperty('IsFulltextInstalled')

Context

StackExchange Database Administrators Q#2131, answer score: 9

Revisions (0)

No revisions yet.