In SQL 2008 full-text catalogs are “virtual.” They are just containers for full-text catalog properties like accent sensitivity or catalog rebuild or population statements. They live inside the database in SQL 2008, unlike SQL 2000 and 2005, where the catalogs and full-text indexes resided in the filesystem.
To build your full-text catalogs and indexes, you need to use the
CREATE FULLTEXT commands.
T-SQL commands are not case sensitive.
There are three commands for full-text index creation and maintenance:
Let’s look at how they work.
CREATE FULLTEXT CATALOG
To create a full-text catalog in its simplest ...