select document_type from sys.fulltext_document_types

 select document_type from sys.fulltext_document_types

create table DocumentRepository
 (
	id int not null primary key identity,
	fileName nvarchar(250),
	fileSize int,
	fileExtension NVARCHAR(10),
	attachment varbinary(max)
 );
 GO
 GRANT INSERT,UPDATE,SELECT,DELETE on DocumentRepository to public;
 GO
 CREATE FULLTEXT CATALOG FTSCatalog AS DEFAULT;
 GO

CREATE FULLTEXT INDEX ON dbo.DocumentRepository
(fileName, attachment TYPE COLUMN fileExtension)
KEY INDEX PK__Document__3213E83FEFB4F2B9
ON FTSCatalog
WITH CHANGE_TRACKING AUTO;
GO

select * from DocumentRepository where contains(*,N'Firefox') 
------
0, слово внутри pdf

select * from DocumentRepository where contains(*,N'Appender')
-----
0, слово внутри .cs

select * from DocumentRepository where contains(*,N'database')
--------
dbw.txt	3	.txt
mydoc.docx	11	.docx

EXEC sp_fulltext_service @action='load_os_resources', @value=1;
EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures 
EXEC sp_fulltext_service 'update_languages'; -- update language list 
EXEC sp_fulltext_service 'restart_all_fdhosts';
EXEC sp_help_fulltext_system_components 'filter'
reconfigure with override

Microsoft SQL Server 2014 - 12.0.4100.1 (X64) 
	Apr 20 2015 17:29:27 
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

/*

Если ключ таблицы на которую построен FTS-индекс не целое число,
то FTS создает доп. таблицу с маппингом source_table_key, internal_int_key.

Имя этой таблицы можно увидеть в плане FTS-запроса.
*/

select * 
from 
	dbo.docs d
		inner join
	freetexttable
	(
		[dbo].[docs],
		[file_stream],
		'FORMSOF(INFLECTIONAL, "минздрав")',
		language N'Russian'
	) ftsr on d.path_locator = ftsr.[key]
where
	ftsr.[rank] > 0
order by
	ftsr.[rank] desc

/*

  |--Compute Scalar(DEFINE:([d].[parent_path_locator]=[drop_me].[dbo].[docs].[parent_path_locator] as [d].[parent_path_locator], [d].[file_type]=[drop_me].[dbo].[docs].[file_type] as [d].[file_type], [d].[cached_file_size]=[drop_me].[dbo].[docs].[cached_file_size] as [d].[cached_file_size]))
       |--Nested Loops(Inner Join, OUTER REFERENCES:([Bmk1000]))
            |--Sort(ORDER BY:(FulltextMatch.[score] DESC))
            |    |--Nested Loops(Inner Join, OUTER REFERENCES:([drop_me].[sys].[fulltext_index_docidmap_245575913].[ftkey]))
            |         |--Nested Loops(Inner Join, OUTER REFERENCES:(FulltextMatch.[docid]))
            |         |    |--Filter(WHERE:(FulltextMatch.[score]>(0)))
            |         |    |    |--Table-valued function
            |         |    |--Clustered Index Seek(OBJECT:([drop_me].[sys].[fulltext_index_docidmap_245575913].[i1]), SEEK:([drop_me].[sys].[fulltext_index_docidmap_245575913].[docid]=FulltextMatch.[docid]) ORDERED FORWARD)
            |         |--Compute Scalar(DEFINE:([d].[parent_path_locator]=CASE WHEN [drop_me].[dbo].[docs].[path_locator] as [d].[path_locator].GetLevel()=(1) THEN NULL ELSE [drop_me].[dbo].[docs].[path_locator] as [d].[path_locator].GetAncestor((1)) END))
            |              |--Index Seek(OBJECT:([drop_me].[dbo].[docs].[PK__docs__5A5B77D5998EFDFC] AS [d]), SEEK:([d].[path_locator]=[drop_me].[sys].[fulltext_index_docidmap_245575913].[ftkey]) ORDERED FORWARD)
            |--RID Lookup(OBJECT:([drop_me].[dbo].[docs] AS [d]), SEEK:([Bmk1000]=[Bmk1000]) LOOKUP ORDERED FORWARD)

У меня это sys.fulltext_index_docidmap_245575913

А потом колупаем. 

Логинимся под DAC
*/

-- select * from sys.internal_tables where name like 'fulltext_%'
sp_help 'sys.fulltext_index_docidmap_245575913'

select d.name, k.*
from 
	sys.dm_fts_index_keywords_by_document(db_id(N'drop_me'), object_id(N'dbo.docs')) k
		inner join
	sys.fulltext_index_docidmap_245575913 fid on fid.docid = k.document_id
		inner join
	dbo.docs d on d.path_locator = fid.ftkey
order by
	d.path_locator