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 2012SELECT [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 2012SELECT [lcid], [name] FROM sys.fulltext_semantic_languages
Back to Top
No comments:
Post a Comment