Before you can specify which columns will make up the full-text index, you must first enable the database and the table itself that will contain the columns.
Enterprise Manager and Transact SQL guide you through the necessary steps to create a full-text index.
Using Enterprise Manager, select the name of your database. Then choose the Tools->Full-text indexing menu option.
This brings up the Full-Text Indexing Wizard, as shown in the dialog box below:
Defining a full-text index with Transact-SQL is quite a bit different than defining a relational index since there is no specific syntax as provided by SQL. The syntax for defining a full-text index is done by using system stored procedures.
In the next lesson, we will write queries to access full-text catalogs.