HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to install SQL Server Express 2005 with Full text search

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
expressinstallfullsearchsqlwithtext2005howserver

Problem

I am in need to Install SQL server 2005 Express edition with Full Text Search capability. I don't know what to download and the order of installing the Database management system. Could someone provide me link to download the version with Full Text Search [as default 38Mb setup file does not have this feature].

Also step by step instruction to enable Full Text Search during the installation.

Solution

Full Text Search features are available in

Microsoft SQL Server 2005 Express Edition with Advanced Services

Microsoft® SQL Server® 2008 Express with Advanced Services

Installation and configuration are pretty simple, hope you have already installed express edition.

Give it a try!

UPDATE: 2011 - MARCH - 08

You will not be able manage Full Text Catalogs via SSMS.


SQL Server Management Studio Express



  • You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.

Context

StackExchange Database Administrators Q#1565, answer score: 6

Revisions (0)

No revisions yet.