--create a catalog EXEC sp_fulltext_catalog 'ims', 'create' --create table / PK EXEC sp_fulltext_table 'masterFL', 'create', 'ims', 'pk_MasterFL' --Add some columns EXEC sp_fulltext_column 'masterFL','Descr','add' EXEC sp_fulltext_column 'masterFL','note','add' --Activate and populate the index EXEC sp_fulltext_table 'masterFL', 'activate' EXEC sp_fulltext_table 'masterFL', 'start_full' --activate and propagate EXEC sp_fulltext_catalog 'ims', 'start_full' -- test it... select * from masterFL where contains(descr, 'green') select * from masterFL where contains(note, 'green') --To remove a full-text index --EXEC sp_fulltext_table 'ims', 'drop'