How to enable Full Text Search using T-SQL
January 11th, 2010
No comments
In order to enable Full Text Search in a Microsoft SQL Server using T-SQL you need to do the following steps:
- Enable Full Text On The Database
- Create The Catalog (if does not exist)
- Add a Full Text Index on a Table
Let’s assume we have a database named SampleDB that has the following schema:
