EXEC sp_fulltext_database 'enable'
go
CREATE FULLTEXT CATALOG mycatalogName
go
CREATE NONCLUSTERED INDEX primaryKeyIndexName
ON FAQ (pkColumnName);
CREATE FULLTEXT INDEX ON dbo.TableName
(
Question
Language 0X0
)
KEY INDEX PK_TableName ON mycatalogName
WITH CHANGE_TRACKING AUTO
No comments:
Post a Comment