Tuesday, October 5, 2010

Fulltext search in sql server

To set fulltext search in sql server follow below steps:


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


Solution By:Rajesh Rolen

Share This!


No comments:

Powered By Blogger · Designed By Seo Blogger Templates