What's Next For Your Venture?
Full-Text Indexing Setup Minimize

To manually create a full-text index in SQL Server 2005 Standard or Enterprise Edition (Not available in SQL Server 2005 Express Edition's SSMSE):

  1. Open SQL Server Enterprise Manager or SQL Server Management Studio (examples here will be for SQL Server 2005)
  2. Connect you your server and database.
  3. Right click on the database and select Properties.
  4. In the left menu (Select a page), click Files
  5. Make sure Use full-text indexing is checked:
    ft1.jpg
  6. Click OK button
  7. Expand Tables for the database
  8. Right click on Venexus_BrainDump
  9. Select Full-Text Index > Define Full-Text Index...
    ft2.jpg
  10. Click Next (Welcome to the SQL Server Full-Text Indexing Wizard)
  11. Click Next (Select an Index)
  12. Under Available Columns, check ArticleAuthor, IndexTitle, IndexURL, and IndexWashedContent
    ft3.jpg
  13. Click Next
  14. Click Next (Select Change Tracking)
  15. In the Select a Catalog and New catalog section add "VenexusSearchEngineCatalog" as the Name
    ft4.jpg
  16. Click Next
  17. Click Next (Define Population Schedules)
  18. Click Finish
  19. Click Close
spacer

hr-fade.jpg

callus.gif