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
/ * register_language db */ Use master EXEC sp_fulltext_semantic_register_language_statistics_db GO