Enabling Full Text

Is it possible to enable full text indexing on SQL Server without
re-installing (assuming that the full text option was not selected when SQL
was first installed)?
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
"Dirk" <Dirk@.discussions.microsoft.com> wrote in message
news:8A7F6B05-3486-44E1-8763-C1F471B053FA@.microsoft.com...
> Is it possible to enable full text indexing on SQL Server without
> re-installing (assuming that the full text option was not selected when
SQL
> was first installed)?
|||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)
"John Kane" wrote:

> 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
>
> "Dirk" <Dirk@.discussions.microsoft.com> wrote in message
> news:8A7F6B05-3486-44E1-8763-C1F471B053FA@.microsoft.com...
> SQL
>
>
|||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
"Dirk" <Dirk@.discussions.microsoft.com> wrote in message
news:C0C7237E-BDAA-47CD-95E7-47A5476C0841@.microsoft.com...
> 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[vbcol=seagreen]
> NT 5.0 (Build 2195: Service Pack 4)
>
> "John Kane" wrote:
2005)[vbcol=seagreen]
issues.[vbcol=seagreen]
and[vbcol=seagreen]
"Full-text[vbcol=seagreen]
when[vbcol=seagreen]