Set up Fulltext Indexes
USE Northwind
EXEC sp_fulltext_database 'enable'
GO
EXEC sp_fulltext_catalog 'Northwind_data', 'create'
GO
EXEC sp_fulltext_table 'products','create', 'Northwind_data', 'PK_Products'
GO
EXEC sp_fulltext_column 'products', 'ProductName', 'add', 0
EXEC sp_fulltext_column 'products', 'QuantityPerUnit', 'add', 0
GO
EXEC sp_fulltext_catalog 'Northwind_data', 'start_full'
GO
SELECT FULLTEXTCATALOGPROPERTY ( 'Northwind_data', 'PopulateStatus' )
GO
SELECT dateadd(ss, FULLTEXTCATALOGPROPERTY ( 'Northwind_data', 'PopulateCompletionAge' ), '1/1/1990' )
GO
EXEC sp_fulltext_table 'products', 'Start_change_tracking'
GO
EXEC sp_fulltext_table 'products', 'Start_background_updateindex'
GO
