SQL Advanced toolkit - full-text feature

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Advanced toolkit - full-text feature

Author

Topic

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-03-06 : 05:09:16

Hi I have installed SQL Server 2005 Enterprise Edition on my laptop and get the following version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)

I know that it cannot install the enterprise version on my OS, but I would like the full-text feature. Therefore I downloaded the SQL Server Express Toolkit and selected to install the full-text feature.

BUt...I still do not have the full-text feature installed. Any ideas why not??? can my version of SQL support it? if not, how do I get my way around this?

My OS is Windows XP Professional Version 2002 SP2

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-06 : 05:16:23

Check that full-text is enabled for the database on which you are working:

Select DatabaseProperty(db_name(), 'IsFulltextEnabled')

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-03-06 : 05:22:42

it returns 0.

If i right click the db - properties - files - enable full-text indexing is blanked out and non-selectable....

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-06 : 05:23:53

That means full-text is not enabled for the database. Please do it and then try again.

Either through SSMS or by query:

EXEC sp_fulltext_database 'enable'

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-03-06 : 05:28:09

I get the error:

(1 row(s) affected)
Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded.

and Select DatabaseProperty(db_name(), 'IsFulltextEnabled') = 0

I installed the Toolkit and specifically selected full-text search to install.....

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-03-06 : 08:32:58

There are two versions of Express you can download. You need the SQL Server Express with Advanced Features (http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx). My guess is you have the plain version of Express installed.

The other alternative is to use the Developer Edition.

-Bill

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources