Express with Advanced Services, can’t create Full Text Index

by

You can’t do this through the wizard, because there are a couple of bugs. Even if I chose not to track changes and not to populate the index when it was finished, I still got an error about SQL Agent:

Cannot load ‘Select or Create Population Schedules’ Full-Text Wizard
form.
SQL Server Agent is not supported on this edition of SQL Server.
(Microsoft.SqlServer.Smo)

In spite of the error, I was able to proceed, but at a further step I finally did receive the error you did. However I had no problem doing the following in DDL:

CREATE TABLE dbo.x
(
  x NVARCHAR(255) NOT NULL CONSTRAINT uq_x UNIQUE(x)
);
GO
CREATE FULLTEXT CATALOG x_catalog;
GO
CREATE FULLTEXT INDEX 
  ON dbo.x(x LANGUAGE 1033) 
  KEY INDEX uq_x ON x_catalog; 
GO

This shows that Express certainly does support Full-Text, it’s just the UI that is a little confused. I suspect it doesn’t know how to tell which version of Express you actually have running.

So in the short term I would recommend using DDL instead of the UI. In fact, since the UI only seems to trip on creating the catalog, you can use the UI to create the indexes if you first create the catalog via DDL…

CREATE FULLTEXT CATALOG x_catalog;

…and then pick that catalog when stepping through the wizard, instead of creating a new one. Of course you’ll also have to ignore the exception regarding SQL Server Agent, but it does not stop the wizard, you can just click OK and ignore it.

I’ve filed a Connect item against Management Studio, please vote for it and hopefully this will be corrected:

I don’t know if that item has been addressed or if it made it over to the new feedback system. I started to search for it but good luck.

More Related Contents:

  1. LocalDB deployment on client PC
  2. How to evaluate hosted full text search solutions?
  3. Can SQL Server Express LocalDB be connected to remotely?
  4. Taking lot of time to read from SQL Server using c#
  5. query sql between two tables [duplicate]
  6. Identity increment is jumping in SQL Server database
  7. SQL Server named instance with Visual Studio 2017 Installer project
  8. STRING_SPLIT in SQL Server 2012
  9. Sequence vs identity
  10. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  11. Why the SQL Server ignore the empty space at the end automatically?
  12. SQL Server equivalent of substring_index function in MySQL
  13. Subquery v/s inner join in sql server
  14. Does Oracle support full text search?
  15. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  16. Cannot load Counter Name data because an invalid index -Exception
  17. Joining multiple tables returns NULL value
  18. Find min and max for subsets of consecutive rows – gaps and islands
  19. SQL/C# – Best method for executing a query
  20. PDO and MySQL Fulltext searches
  21. Use TO_DATE in SQL Server 2012
  22. How to pivot unknown number of columns & no aggregate in SQL Server?
  23. “No backupset selected to be restored” SQL Server 2012
  24. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  25. Try_Convert for SQL Server 2008 R2
  26. How do I connect to a SQL database from C#?
  27. How to get Previous Value for Null Values
  28. Can’t create stored procedure with table output parameter
  29. How to sort MYSQL fulltext search results by relevancy
  30. Code first custom SQL migration timeout exception

Leave a Comment