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
add comment

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.