Add full-text index in Script Mode

-- Adding full-text indexes in script mode is not required, but sometimes Enterprise Manager cannot be used to connect to SQL Server. I have encountered this situation today. By the way, some people may need it.

 

-- Create a Fulltext catalog
Exec sp_fulltext_catalog 'catalogname', 'create'

-- Create a full-text index for the target table. If a full-text index already exists, delete it first. The uniqueindexname is the unique index name in the target table (required)
Exec sp_fulltext_table 'tablename', 'drop'
Exec sp_fulltext_table 'tablename', 'create', 'catalogname', 'uniqueindexname'

-- Add columns to the full-text index
Exec sp_fulltext_column 'tablename', 'column1 ', 'add', null, null
Exec sp_fulltext_column 'tablename', 'column2 ', 'add', null, null

-- Activate full-text index
Exec sp_fulltext_table 'tablename', 'activate'