Month: August 2013

View Full Text Catalog Content

USE AdventureWorks2012;
SELECT *
FROM sys.dm_fts_index_keywords(DB_ID(‘AdventureWorks2012’), OBJECT_ID(‘Production.Document’) )
ORDER BY document_count

 

Column name Data type Description
keyword nvarchar(4000) The hexadecimal representation of the keyword stored inside the full-text index.

Note Note
OxFF represents the special character that indicates the end of a file or dataset.
display_term nvarchar(4000) The human-readable format of the keyword. This format is derived from the hexadecimal format.

Note Note
The display_term value for OxFF is “END OF FILE.”
column_id int ID of the column from which the current keyword was full-text indexed.
document_count int Number of documents or rows containing the current term.

 

You may need to rebuild to get the latest

ALTER FULLTEXT CATALOG chinese REBUILD WITH ACCENT_SENSITIVITY = OFF