Posted by Hugo Kornelis on 11/10/36 11:52

On Mon, 10 Jul 2006 13:16:49 +0200, R.A.M. wrote:

>Hello,
>I am learning SQL Server 2005 Expres Edition. I need to create full
>text index on Books.Remarks column in my database. I tried:
>
>CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT
>CREATE FULLTEXT INDEX ON Books (Remarks) KEY INDEX IX_Books_Remarks ON
>FTC_Books
>
>Unfortunately I got error:
>
>Full-Text Search is not installed, or a full-text component cannot be
>loaded.
>
>I don't understand this because I marked all options during setup.
>Please help
>/RAM/

Hi RAM,

Which version of SQL Server Express did yoou download? The "normal"
ediition ("SQL Server 2005 Express Edition" or "SQL Server 2005 Express
Edition SP1"), or the extended version ("SQL Server 2005 Express Edition
with Advanced Services SP1")?

As yoou can see on the feature comparison chart
(http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx),
Full-text Search is only available for SQL Server Express in the SQL
Server Express with Advanced Services download.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Make and save a blob on the fly in stored proc
• Prev in forum: Re: Databse Link will not connect
• Thread view: Re: 2005 EE: using full-text indexing

[Reply to this message]