December 6, 2012

Semantic Search Catalog Views

Se more view version maps here: Microsoft Sql System View Version Maps

sys.fulltext_semantic_language_statistics_database

Returns a row about the semantic language statistics database installed on the current instance of SQL Server. You can query this view to find out about the semantic language statistics component required for semantic processing.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
database_id       int ID of the database, unique within an instance of SQL Server.
register_date       datetime Date the database was registered for semantic processing.
registered_by       int ID of the server principal that registered the database for semantic processing.
version       nvarchar(128) The latest version information specific to the semantic language statistics database.

TSQL

Sql 2012
SELECT [database_id], [register_date], [registered_by], [version] FROM sys.fulltext_semantic_language_statistics_database

Back to Top


sys.fulltext_semantic_languages

language whose statistics model is registered with the instance of SQL Server. When a language model is registered, that language is enabled for semantic indexing. This catalog view is similar to sys.fulltext_languages (Transact-SQL)1.

Column name Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Type Description
lcid       int Microsoft Windows locale identifier (LCID) for the language.
name       sysname Is either the value of the alias in sys.syslanguages (Transact-SQL)2 corresponding to the value of lcid, or the string representation of the numeric LCID.

TSQL

Sql 2012
SELECT [lcid], [name] FROM sys.fulltext_semantic_languages

Back to Top

No comments:

Post a Comment

Total Pageviews