TSD3032: You cannot use this statement when you create a full-text index in a database project.

This error occurs when you add a statement other than an ALTER FULLTEXT INDEX/sp_fulltext_column that adds columns after the main CREATE FULLTEXT INDEX/sp_fulltext_table. This error occurs if you add any other ALTER FULLTEXT INDEX/sp_fulltext_column.

To correct this error

• You must move any other ALTER FULLTEXT INDEX statements to the post-deployment script of your database project.

Example

This error appears if you create a full-text index to your database project that contains the following:

CREATE FULLTEXT INDEX ON [TableOrViewName] (ColumnName)
KEY INDEX [UniqueIndexName] 
ON [FulltextCatalogName] 
WITH CHANGE_TRACKING AUTO;
ALTER FULLTEXT INDEX ON [TableOrViewName] ENABLE;

See Also

Tasks

How to: Specify Pre-Deployment or Post-Deployment Scripts

Concepts

An Overview of Database Scripts