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
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?