Full-text search in SQL Server Express 2005

29 01 2008

Hey, I’m not gonna re-invent the wheel. There are plenty of other sites that detail this. However, I want to note a few things:

  1. SQL Server 2005 Express is limited to 4GB per database. Keep that in mind.
  2. If you want full-text searching on it, you’ll need to download the pack with Advanced Services. (This installs nicely over an existing SQL Server Express 2005).
  3. You get to use the sweet FREETEXT and CONTAINS t-sql commands to do comparison and thesaurus-enabled searches.