Adding FULLTEXT Structures to Database

1. Start SQL Server Management Studio

2. Click the New Query button to open the query editor, and create the FULLTEXT catalog using the following

3. Now that the FULLTEXT catalog is set up, it’s time to create the FULLTEXT indexes in our tables. Using
SQL Server Management Studio, right-click the Table1(we want to add full text on this table) table and select Design.

4. From the Table Designer menu, choose Full-text Index. In the window that shows up, click Add to add
a new FULLTEXT index.

5. You need to specify the columns of the Table1 table that you want indexed. Open the column selector
window (by clicking the “…” button), and select the Col1 and Col2 columns.

6. Finally, click Close, and then press Ctrl+S to save the changes to the table. Now open a new query
window and execute the following query to ensure the index is working as expected:
FROM Table1
WHERE Contains (Col1, ‘FORMSOF(INFLECTIONAL, Young)’, LANGUAGE ‘English’)


Beginning ASP.NET E-Commerce in C#: From Novice to Professional (Expert’s Voice in .NET)

By simplemsexchange Posted in SQL 2008

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s