--1 Create the Catalog 
CREATEFULLTEXT CATALOG [TCKimlikNoCatalogs]
IN PATH N'E:SQLServerDataFTCatalogs'
WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION [dbo]

--2 Add a full text index to a table
EXEC sp_fulltext_table 'TCKimlikNo', 'create', 'TCKimlikNoCatalogs', 'PK_TCKimlikNo'

--3 Add a column to the full text index
EXEC sp_fulltext_column 'TCKimlikNo', 'KIMLIKNO', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'SOYADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADRESILADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADRESCADDE', 'add'

--4 Activate the index
EXEC sp_fulltext_table 'TCKimlikNo', 'activate'
EXEC sp_fulltext_table 'TCKimlikNo', 'Start_background_updateindex'

--5 Start full population
EXEC sp_fulltext_catalog 'TCKimlikNoCatalogs', 'start_full'