2005 EE: using full-text indexing

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/On Mon, 10 Jul 2006 13:16:49 +0200, R.A.M. wrote:

Quote:

Originally Posted by

>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/prodin...-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|||On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>Full-text Search is only available for SQL Server Express in the SQL
>Server Express with Advanced Services download.

Now I have installed Advanced Services. But full-text search does not
work... Could you help me please?|||On Wed, 19 Jul 2006 09:03:19 +0200, RAM wrote:

Quote:

Originally Posted by

>On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
><hugo@.perFact.REMOVETHIS.info.INVALIDwrote:
>

Quote:

Originally Posted by

>>Full-text Search is only available for SQL Server Express in the SQL
>>Server Express with Advanced Services download.

>
>Now I have installed Advanced Services. But full-text search does not
>work... Could you help me please?

Hi RAM,

I'm sorry. I know from googling that full-text is included in Advanced
Services, but I've never worked with or installed full-text search in
any edition of SQL Server.

Maybe you should ask this in microsoft.public.sqlserver.fulltext. The
experts there will probably be better equipped to help you.

--
Hugo Kornelis, SQL Server MVP|||On Thu, 20 Jul 2006 23:06:51 +0200, Hugo Kornelis
<hugo@.perFact.REMOVETHIS.info.INVALIDwrote:

Quote:

Originally Posted by

>On Wed, 19 Jul 2006 09:03:19 +0200, RAM wrote:
>

Quote:

Originally Posted by

>>On Mon, 10 Jul 2006 23:15:36 +0200, Hugo Kornelis
>><hugo@.perFact.REMOVETHIS.info.INVALIDwrote:
>>

Quote:

Originally Posted by

>>>Full-text Search is only available for SQL Server Express in the SQL
>>>Server Express with Advanced Services download.

>>
>>Now I have installed Advanced Services. But full-text search does not
>>work... Could you help me please?

>
>Hi RAM,
>
>I'm sorry. I know from googling that full-text is included in Advanced
>Services, but I've never worked with or installed full-text search in
>any edition of SQL Server.
>
>Maybe you should ask this in microsoft.public.sqlserver.fulltext. The
>experts there will probably be better equipped to help you.

I don't see the group microsoft.public.sqlserver.fulltext.|||On Thu, 27 Jul 2006 15:12:35 +0200, RAM <r_ahimsa_m@.poczta.onet.pl>
wrote:

Quote:

Originally Posted by

>I don't see the group microsoft.public.sqlserver.fulltext.

It does exist:

http://groups.google.com/group/micr...server.fulltext
Not all news servers carry all the newsgroups. For the Microsoft
groups it is best to get them directly from the Microsoft news servers
at msnews.microsoft.com.

Roy Harvey
Beacon Falls, CT