EXEC sp_fulltext_database 'enable'
go
CREATE FULLTEXT CATALOG MyFTSCatalog
go
CREATE FULLTEXT INDEX ON MyTable
(
Document
TYPE COLUMN DocumentExtension
LANGUAGE 0x0407 --this is German
)
KEY INDEX PK_MyTable
ON MyFTSCatalog
go--to populate the catalog,--do the following when traffic is light:
ALTER FULLTEXT INDEX ON Production.Document SET CHANGE_TRACKING AUTO;
GO
FTS: Create new Catalog
See: how to drop existing FTS Catalog
Labels:
full text search tutorial
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment