Blog Posts on full text search tutorial




Percent:
 
Distinct:
 


FTS: Drop Catalog by Being (me) on Mar 25, 2010sp_fulltext_table 'MyTable', 'drop'gosp_fulltext_database 'enable'gosp_fulltext_catalog 'MyFTSCatalog', 'drop'gosp_fulltext_service 'clean_up'go...



FTS: Create new Catalog by Being (me) on Mar 25, 2010See: how to drop existing FTS CatalogEXEC sp_fulltext_database 'enable'goCREATE FULLTEXT CATALOG MyFTSCataloggoCREATE FULLTEXT INDEX ON MyTable( Document TYPE COLUMN DocumentExtension LANGUAGE 0x...



Full Text Search Step by Step Tutorial by Being (me) on Sep 18, 2008Download and Install AdventureWorks for SQL Server 2008Download AdventureWorks database: AdventureWorksDB.msi in CodeplexThen double click your .msi file to Install your database.By default it will install your database inC:Program Files (x86)Micro...