"John Kane" <jt-kane@comcast.net> wrote in message
news:737946df.0402251744.290b36fb@posting.google.com...
> Sky Fly,
> The most likely problem is either a missing registry key &/or missing
> dll.
> You most likely will have to "re-install" the "Full-text Search"
> components
> via deleting (or renaming) the below "tracking key" and re-install (If
> you're not using a named instance, remove "<Instance_Name>\".)
>
> NOTE: be sure to be logged on to the server as either Administrator or
> as a
> member of the server's Admin Group! The below registry key assumes
> that you are using SQL Server 2000:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\<Instance_Name>\Tracking\
> {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
>
> Once you've done removed (renamed) the above tracking key, then delete
> the
> MSSearch directory from either:
>
> drive_letter:\Program Files\Common Files\Microsoft Shared\
> or
> drive_letter:\Program Files\Common Files\System\
>
> Then using your SQL Server 2000 installation CD re-install via "Custom
> Installation" the Full-Text Search component (it should be
> un-checked). When
> this completes find and save these files: SearchSetup.log (usually
> under
> \windows or \winnt folders) and sqlsp.log. If any problems, please
> post
> these files.
>
> Re-install SQL Server 2000 SP3a, so that the newly installed MSSearch
> components are upgraded to SP3a levels.
> Re-boot &/or restart the MSSearch and MSSQLServer services.
>
> Note, if the method above fails (and there are other methods) you
> might need
> to open a support case with Microsoft PSS SQL Server Support...
> Regards,
> John
>
>
> "Sky Fly" <nobody@blackhole.com> wrote in message
news:<c1ip8j$1jna05$1@ID-18325.news.uni-berlin.de>...
> > Hello,
> >
> > I have a problem with enabling my database for full-text indexing. Every
> > time I run
> >
> > sp_fulltext_database 'enable'
> >
> > I get
> >
> > Server: 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.
> >
> > I checked/done the necessary things:
> >
> > The Microsoft Search service is running.
> >
> > I've reinstalled the full text component from the
> > SQL Server setup disk.
> >
> > Running select @@version gives me
> >
> > 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)
> >
> > I've tried to enable full text indexing from
> > Enterprise Manager, but the option is disabled
> > there.
> >
> > Is there anything else I can try?
> >
> > Thanks,