Take the 2-minute tour ×
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.

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;
GO 

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*/
SELECT SERVERPROPERTY('IsFullTextInstalled');
GO

I also registered the 'language_statistics_db'.

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

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;
GO

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
GO

And registering:

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.