2012年3月21日星期三

Full Text option install

I have been trying to figure out why my full text menu option is not
working and it seems it is not installed.
I did get a 0 when I did the:
SELECT fulltextserviceproperty('IsFulltextInstalled')
Why wouldn't it be installed? Is it a special option? How do I install it.
Here is the results from select @.@.version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Thanks,
Tom.It is not selected by default in the setup program. Run setup again and
select the ft index service.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A22E4.9090902@.deltanet.com...
> I have been trying to figure out why my full text menu option is not
> working and it seems it is not installed.
> I did get a 0 when I did the:
> SELECT fulltextserviceproperty('IsFulltextInstalled')
> Why wouldn't it be installed? Is it a special option? How do I install
it.
> Here is the results from select @.@.version
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> Thanks,
> Tom.
>|||Tibor Karaszi wrote:
> It is not selected by default in the setup program. Run setup again and
> select the ft index service.
>
Does this have to be run from the CD, or can it be run off the harddisk
with what is already there?
Thanks,
Tom.
>|||Thomas Scheiderich wrote:
> Tibor Karaszi wrote:
>> It is not selected by default in the setup program. Run setup again and
>> select the ft index service.
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
When I try to load from the CD, it will only allow me to load the full
install (either desktop or standard). There doesn't seem to be a way to
install optional items the way 6.5 did.
> Thanks,
> Tom.
>|||I have an instance named FRESH on my machine. Insert he DVD (correct
edition, of course), Autorun, SQL Server 2000 Components, Install Database
Server. And then I get an option to "Upgrade, remove or add components to an
existing installation". The name of this dialog is "Installation Selection
and the other two options are "Create a new instance..." and "Advanced
options".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404A2753.2090806@.deltanet.com...
> Tibor Karaszi wrote:
> > It is not selected by default in the setup program. Run setup again and
> > select the ft index service.
> >
> Does this have to be run from the CD, or can it be run off the harddisk
> with what is already there?
> Thanks,
> Tom.
> >
>|||Tibor Karaszi wrote:
> I have an instance named FRESH on my machine. Insert he DVD (correct
> edition, of course), Autorun, SQL Server 2000 Components, Install Database
> Server. And then I get an option to "Upgrade, remove or add components to an
> existing installation". The name of this dialog is "Installation Selection
> and the other two options are "Create a new instance..." and "Advanced
> options".
>
You're right. When I ran the install further, it allows me to install
other options.
But the only other 2 options not chose are development tools and code
samples. Everything else is checked.
So, why isn't full text search not showing? Could it be because on this
machine I only have the desktop version running?
Tom.
>|||Hmm, according to Books Online for SQK2K, FT is supported for Personal
Edition (except for Windows 98). Is there a "Microsoft Search" service on
your machine?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:404AAACA.5090205@.deltanet.com...
> Tibor Karaszi wrote:
> > I have an instance named FRESH on my machine. Insert he DVD (correct
> > edition, of course), Autorun, SQL Server 2000 Components, Install
Database
> > Server. And then I get an option to "Upgrade, remove or add components
to an
> > existing installation". The name of this dialog is "Installation
Selection
> > and the other two options are "Create a new instance..." and "Advanced
> > options".
> >
> You're right. When I ran the install further, it allows me to install
> other options.
> But the only other 2 options not chose are development tools and code
> samples. Everything else is checked.
> So, why isn't full text search not showing? Could it be because on this
> machine I only have the desktop version running?
> Tom.
> >
>|||Tibor Karaszi wrote:
> Hmm, according to Books Online for SQK2K, FT is supported for Personal
> Edition (except for Windows 98). Is there a "Microsoft Search" service on
> your machine?
>
No. There is an indexing service, but that appears to be for something else.
I also have SQL server 7 loaded on my MS2K server as a standard edition
and it doesn't work there, either.
Tom

没有评论:

发表评论