SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search

CodeProject: SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search. Free source code and programming help

Full Text Index helps to perform complex queries against character data. These queries can include word or phrase searching. We can create a full-text index on a table or indexed view in a database. Only one full-text index is allowed per table or indexed view. The index can contain up to 1024 columns. This feature works with RTM (Ready to Manufacture) version of SQL Server 2008 and does not work on CTP (Community Technology Preview) versions.
To create an Index, follow the steps:
Create a Full-Text Catalog
Create a Full-Text Index
Populate the Index