Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When trying to install a semantic search example, I'm running into a problem.

There are some steps in the example to check if the 'new' Semantic Search and Full Text Search are installed.

Executing the following T-SQL code returns the version '11.0.1153.1.1' of the semantic database.

/* Verify the registration is succeeded */
SELECT * FROM sys.fulltext_semantic_language_statistics_database;

And...the following T-SQL code returns 1, which indicates that Full-Text Search and Semantic Search are installed.

/* Check if Full-Text Search and Semantic Search are installed*/

I also registered the 'language_statistics_db'.

/* Register Language Statistics Database */
EXEC sp_fulltext_semantic_register_language_statistics_db 'semanticsdb';

I'm executing the following T-SQL code to verify if the languages are installed correctly (this is were something odd happens).

/* Check available languages for statistical semantic extraction */
SELECT * FROM sys.fulltext_semantic_languages;

This statement returns no rows, indicating that there are no languages installed. I tried reinstalling the database(s) but with no effect.

Can someone point out to me were I made a mistake?

UPDATE: After unregistering the semantic_language database and registering it using 'master' it worked. No idea why this worked. Why? Someone?

The code that worked for me:

/ * Unregistar language db */ 
EXEC sp_fulltext_semantic_unregister_language_statistics_db

And registering:

/ * register_language db */ 
Use master
EXEC sp_fulltext_semantic_register_language_statistics_db
share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.