Re: Full text search writing messages in eventlog

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 08/09/04 

Date: Sun, 8 Aug 2004 21:36:39 -0700

Atiq,
The short answer for SQL Server 2000 is no. The longer answer is I filed a
DCR (Documented Change Request) for this while at Microsoft and I believe
that it was deferred to Yukon (SQL Server 2005) for resolution. You can
always set your Event log to "overwrite events as needed" or "overwrite
events older than X days" and you can set the day parameter. , otherwise,
you will have to wait until SQL Server 2005 is released...

Regards,
John

"Atiq Rahman" <atiqrahman@rediffmail.com> wrote in message
news:OCTICDVfEHA.1356@TK2MSFTNGP09.phx.gbl...
> Hi All
>
> I am using SQL server 2000 with SP3 on Windows 2003 server.
>
> I have scheduled a job to populate a full text index incrementally.
> Everytime it runs the job to populate the index table it writes some
> messages into event log.
> Like this:
> 1.
> Event Type : Information
> Event Source : Microsoft Search
> Event Category: Gatherer
> Event ID : 3019
> Date :8/7/2004
> Time :2:21:00 PM
> User : N/A
> Computer : ARC-03-DEV
> Description:1
> The crawl on project <SQL Server SQL00002000009> has started.
>
> 2.
> Event Type : Information
> Event Source : Microsoft Search
> Event Category: Gatherer
> Event ID : 3047
> Date :8/7/2004
> Time :2:21:00 PM
> User : N/A
> Computer : ARC-03-DEV
> Description:
> The end of the incremental crawl for project <SQL Server SQL00002000009>
> has been detected. The Gatherer successfully processed 998 documents
> totaling 0K. It failed to filter 0 documents. 998 documents were
> modified. 0 URLs could not be reached or were denied access.
>
> The event log is getting filled frequently.
>
> Is there any way to stop this messages?
> It is normal for Microsoft Search to write this message into EventLog?
> Even though there is no chanage in the database it give the above
> messages.
>
> Any one know the reason please help.
>
> Quick reply is highly appreaciated.
>
> Regards,
>
> Atiq Rahman
> Database Administrator
> Zuhair Fayez Partnership
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages