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:
- SQL Server 2005 Express is limited to 4GB per database. Keep that in mind.
- 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).
- You get to use the sweet FREETEXT and CONTAINS t-sql commands to do comparison and thesaurus-enabled searches.