By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,600 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,600 IT Pros & Developers. It's quick & easy.

2005 EE: using full-text indexing

P: n/a
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/
Jul 10 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Jul 10 '06 #2

P: n/a
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?

Jul 19 '06 #3

P: n/a
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
Jul 20 '06 #4

P: n/a
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.
Jul 27 '06 #5

P: n/a
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
Jul 27 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.