--Find out if the database has been enabled for full-text processing by executing this statement:
SELECT DatabaseProperty ('Northwind', 'IsFulltextEnabled' )
go
-enable if no
sp_fulltext_database 'enable'
go
--Create a full-text catalog named NWCatalog, opting for the default directory, by executing this stored procedure:
sp_fulltext_catalog 'NWCatalog', 'create'
go
--Register table for full-text processing by executing this stored procedure once for each table:
sp_fulltext_table 'Employees', 'create', 'NWCatalog', 'PK_Employees'
-- specify the names of the columns that are to support full-text queries by executing this stored procedure once for each column:
sp_fulltext_column 'Employees', 'LastName', 'add'
--Create a full-text index for these tables by executing this stored procedure once for each table:
sp_fulltext_table 'Employees', 'activate'
--Start a full population of the NWCatalog full-text catalog by executing this stored procedure:
sp_fulltext_catalog 'NWCatalog', 'start_full'

--Verify the progress of the population of the NWCatalog full-text catalog by executing this statement:
SELECT FulltextCatalogProperty ( 'NWCatalog', 'PopulateStatus')
-- Check if the column enabled for fill-text search
SELECT ColumnProperty ( Object_Id('Employees'), 'LastName', 'IsFullTextIndexed' )
-- start gathering catalogue
sp_fulltext_catalog 'NWCatalog', 'start_incremental'