Enabling Full Text -- sql server full text search

John Kane
8/22/2004 8:01:53 PM

Dirk,
Yes. However, it depends upon the SQL Server version (7.0, 2000 or now 2005)
that you are using.... Could you post the full output of -- SELECT
@@version -- as this is very helpful info in troubleshooting SQL FTS issues.

FYI, SQL Server 2000 installs the Full-text Search (FTS) components by
default, while SQL Server 7.0 doesn't, but you can use your SQL 7.0 CD and
use "custom installation" and under the server components, select "Full-text
Search".

Regards,
John

[quoted text, click to view]

Dirk
8/23/2004 5:19:01 PM

Here it is:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)

[quoted text, click to view]

John Kane
8/23/2004 5:29:14 PM

Dirk,
I stand corrected... "SQL Server 2000 installs the Full-text Search (FTS)
components by default," should of been "SQL Server 2000 installs the
Full-text Search (FTS) components by default for Standard Edition and
above". Since, you're using Developer Edition (and THAT is why I asked for
the @@version info!), this edition does NOT install the FTS components by
default and you can use the same procedures as I described for SQL Server
7.0....

Basically, you can use your SQL 2000 Developer Edition CD and run setup and
select "custom installation" and under the server components select
"Full-text Search" and the CD will install these components for you. Note,
if you have applied any Service Pack (SPx) to your Developer Edition, you
will need to re-install the SP as well so that any FTS &/or MSSearch fixes
can be applied.

Regards,
John

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server full text search

sql server full text search : Enabling Full Text