Checkout the final part of this two part article series here, in which I discussed how to create full-text index using Transact-SQL, and how to manage and optimize full-text search catalogs and indexes.

This article is published on SSWUG.org.