Re: full-text indexing greyed out

From: Fulya Erol (ferol_at_no.nospam.mezun.com)
Date: 03/01/04


Date: Mon, 1 Mar 2004 10:18:30 -0500

When I go to the wizards, there is no option to install full index. When I
run SELECT fulltextserviceproperty('IsFulltextInstalled') in query analyzer
it shows 0 which means full text indexing is not installed. But when I want
to add full text indexing as a component from the CD, it shows that it's
already installed. That's the reason I can't remove it and reintsall it
again. Do you know what the problem is?

"Wayne Snyder" <wsnyder@computeredservices.com> wrote in message
news:#UKznp5$DHA.2448@TK2MSFTNGP12.phx.gbl...
> Full Text requires a unique index on a table... Make sure you have one..
>
> Additionally , go to the wizards and install full text search...(this is
in
> SQL Enterprise Manager)
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
>
> "Fulya Erol" <ferol@no.nospam.mezun.com> wrote in message
> news:OK2ugU5$DHA.1796@TK2MSFTNGP12.phx.gbl...
> > I have SQL 2000 running and when I check the services MSSearch is
running
> > with no problems, but when I right click on a table , full text index is
> > greyed out. It looks like full text indexing is not installed although
> > Microsoft search service is running , how can I fix this problem?
> >
> > Thanks in advance..
> >
> >
>
>



Relevant Pages

  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • Re: Installed VS 2005 want to Manage SQL 2005 Server
    ... Microsoft SQL Server Management Studio 9.00.3042.00 ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ... If you later install a more recent service pack, this service pack will be uninstalled automatically. ... How to uninstall SQL Server Management Studio ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Server Express on SBS2003 standard
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... After you applied the SBS 2003 SP1 successfully, you can install the ... SQL Server Express on SBS. ...
    (microsoft.public.windows.server.sbs)