SQL Set up Fulltext Indexes
SQL
Download (.zip)
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
|