Re: Full Text Repair
From: John Kane (jt-kane_at_comcast.net)
Date: 07/31/04
- Previous message: Emil: "Re: Full Text Repair"
- In reply to: Emil: "Re: Full Text Repair"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 19:19:47 -0700
Emil,
Since your customer has already applied SP4, I'm assuming that this is a SQL
Server 7.0 installation as there currently is no publicly released SP4 for
SQL Sever 2000.
For SQL Server 7.0 installations, there is a registry key and value that you
can change in order to successfully re-install SP4 after applying a post-SP4
hotfix. Specifically, registry key called
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQL Server\Current Version\
"CSDVersion"
It will contain your hotfix build version number such that 7.00.xxx is the
build number. Record this value and then change it to the SP4 build value of
7.00.1063 and then re-install SP4. If successful, then re-install your
hotfix and confirm that this registry key value has changed back to your
recorded hotfix build number.
BTW, the hex value in the unknown result below is a 'garbage' value as this
is a bug with SQL Server 7.0 FTS and is fixed by applying (or re-applying)
the latest service pack.
Regards,
John
"Emil" <Emil@discussions.microsoft.com> wrote in message
news:76173F35-121A-4ED7-852F-3328824CEC69@microsoft.com...
> use culture;
> SELECT * from FREETEXTTABLE(tblMasterEvents,*,'art');
>
> Get this:
> Search on full-text catalog 'culture' for database ID 41, table ID
> 1381579960 with search condition 'art' failed with unknown result
(565f9c4).
>
>
> The name of the database is not relevant, as all return the error.
>
> Thanks for looking.
> --
> Emil Caruthers
>
>
> "Hilary Cotter" wrote:
>
> > what is the exact error message you are getting?
> >
> > --
> > Hilary Cotter
> > Looking for a book on SQL Server replication?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Emil" <emilcaruthers@hotmail.com> wrote in message
> > news:698301c4758b$4e941cd0$a301280a@phx.gbl...
> > > We had a customer request a full text installation after
> > > the application of SP4 and the slammer hotfix. It throws
> > > an error that refers to a re-installation of SP4, which
> > > will not work with any hot fixes applied after the fact.
> > >
> > > Does anyone have a different route to follow that
> > > uninstall the hotfix, then reapply the SP4, and then
> > > reapply the hot fix??
> > >
> > > Thanks in advance for any information.
> > >
> > > Emil
> >
> >
> >
- Previous message: Emil: "Re: Full Text Repair"
- In reply to: Emil: "Re: Full Text Repair"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
