2005 EE: using full-text indexing

[R.A.M.]

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/

[Hugo Kornelis]

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/prodinf...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

[RAM]

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

>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?

[Hugo Kornelis]

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

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

>>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

[RAM]

On Thu, 20 Jul 2006 23:06:51 +0200, Hugo Kornelis
<hu**@perFact.REMOVETHIS.info.INVALIDwrote:

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

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

>>>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.

[Roy Harvey]

On Thu, 27 Jul 2006 15:12:35 +0200, RAM <r_********@poczta.onet.pl>
wrote:

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

It does exist:

http://groups.google.com/group/micro...erver.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