/*Create unique index on needed table*/

CREATE UNIQUE INDEX index_name ON Table_name(column_name to be defined unique)

/*Create Full Text Catalog*/

USE database_name;

GO

CREATE FULLTEXT CATALOG fullTextCatalog_name AS DEFAULT;

GO

/*Create Full Text index*/

CREATE FULLTEXT INDEX ON Table_name (col1,col2,.....to define full-text index on ) KEY INDEX index_name;

GO

EXAMPLE:

CREATE UNIQUE INDEX UQ_CompanyId ON CompanyMaster (CompanyId)

/*Create Full Text Catalog*/

USE Database1;

GO

CREATE FULLTEXT CATALOG FTCatalog AS DEFAULT;

GO

/*Create Full Text index*/

CREATE FULLTEXT INDEX ON CompanyMaster (CompanyAddress,CompanyName) KEY INDEX UQ_CompanyId;

GO