Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
Tom
Tom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom
|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
Tom
"Uri Dimant" wrote:

> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>
>
|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.

> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
--
TomTom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
--
Tom
"Uri Dimant" wrote:

> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>
>|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.

> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>

Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
--
TomTom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
--
Tom
"Uri Dimant" wrote:
> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
> >I can't find any information to correct the following warning message that
> >I
> > receive in Event Viewer.
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3055
> > Description: The gatherer property mapping file cannot be opened. Error:
> > 80070003. The default values are being used. You may have to copy the
> > property mapping file from the Setup CD-ROM, or reinstall the application.
> >
> > Environment:
> > Windows 2000 Server SP4
> > SQL Server 2000 SP4 Standard Edition (8.00.2039)
> > MDAC 2.81.1117.6
> >
> > The server is not in a cluster, and doesn't have Exchange installed. Any
> > assistance would greatly be appreciated!!!
> > --
> > Tom
>
>|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>>I can't find any information to correct the following warning message that
>>I
>> receive in Event Viewer.
>> Event Type: Warning
>> Event Source: Microsoft Search
>> Event Category: Gatherer
>> Event ID: 3055
>> Description: The gatherer property mapping file cannot be opened.
>> Error:
>> 80070003. The default values are being used. You may have to copy the
>> property mapping file from the Setup CD-ROM, or reinstall the
>> application.
>> Environment:
>> Windows 2000 Server SP4
>> SQL Server 2000 SP4 Standard Edition (8.00.2039)
>> MDAC 2.81.1117.6
>> The server is not in a cluster, and doesn't have Exchange installed. Any
>> assistance would greatly be appreciated!!!
>> --
>> Tom
>

Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, Oskar
A comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:

> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, OskarA comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:
> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application v. Error log. Will I miss anything important?

Hi,
Will I miss anything important in MS SQL Server 2000 if I monitor only MS
Windows 2000 application event log and don't monitor SQL Server error log?
What exactly will I miss?
-- Many thanks, OskarA comment to my previous post.
I suppose errors with severity 19 an higher ar logged into Windows
Application log, so I shouldn't miss any of them when they happen. Is that
true? Also if in SQL Server Enterprise Manager I configure a particular
message so that it is logged, I should see it in Application event log too,
right?
-- Thanks again, Oskar.
"Oskar" wrote:

> Hi,
> Will I miss anything important in MS SQL Server 2000 if I monitor only MS
> Windows 2000 application event log and don't monitor SQL Server error log?
> What exactly will I miss?
> -- Many thanks, Oskar
>

Application Log - Overwrite as Needed

In the event viewer: In Application Log properties, there are options on
what to do "When maximum log size is reached." I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."
Why does it do this and how can I make it stop? It has been going on for
several months.Sheila,
If it is possible, perhaps a Group Policy at a higher level could be making
this change.
HTH
Jerry
"Sheila" <Sheila@.discussions.microsoft.com> wrote in message
news:E4ADF2FF-F543-4FC6-A2E4-8CB0E717850F@.microsoft.com...
> In the event viewer: In Application Log properties, there are options on
> what to do "When maximum log size is reached." I set it to "Overwrite as
> Needed", but the next day it is changed to "Overwrite Events Older than 5
> Days."
> Why does it do this and how can I make it stop? It has been going on for
> several months.
>

Application Log - Overwrite as Needed

In the event viewer: In Application Log properties, there are options on
what to do "When maximum log size is reached." I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."
Why does it do this and how can I make it stop? It has been going on for
several months.
Sheila,
If it is possible, perhaps a Group Policy at a higher level could be making
this change.
HTH
Jerry
"Sheila" <Sheila@.discussions.microsoft.com> wrote in message
news:E4ADF2FF-F543-4FC6-A2E4-8CB0E717850F@.microsoft.com...
> In the event viewer: In Application Log properties, there are options on
> what to do "When maximum log size is reached." I set it to "Overwrite as
> Needed", but the next day it is changed to "Overwrite Events Older than 5
> Days."
> Why does it do this and how can I make it stop? It has been going on for
> several months.
>

Application Log - Overwrite as Needed

In the event viewer: In Application Log properties, there are options on
what to do "When maximum log size is reached." I set it to "Overwrite as
Needed", but the next day it is changed to "Overwrite Events Older than 5
Days."
Why does it do this and how can I make it stop? It has been going on for
several months.Sheila,
If it is possible, perhaps a Group Policy at a higher level could be making
this change.
HTH
Jerry
"Sheila" <Sheila@.discussions.microsoft.com> wrote in message
news:E4ADF2FF-F543-4FC6-A2E4-8CB0E717850F@.microsoft.com...
> In the event viewer: In Application Log properties, there are options on
> what to do "When maximum log size is reached." I set it to "Overwrite as
> Needed", but the next day it is changed to "Overwrite Events Older than 5
> Days."
> Why does it do this and how can I make it stop? It has been going on for
> several months.
>

Application Event log message

Recently, I have been seeing the following event(s) in the application event
log on a number of my SQL servers. I have Googled this and get the
impression that it can just be ignored, but these are becoming more
frequent, and was wondering if anyone here could shed a bit more light on
the cause, and any possible way of preventing them. All instances running
SQL 2000 SP3 (or SP3a)
Source: SQLSERVERAGENT
Category: Alert Engine
Event ID: 322
Message: The data portion of event 19004 from MSSQLSERVER is invalid.
R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA (SQL2000)Its just a bug...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;230393
Peter
>--Original Message--
>Recently, I have been seeing the following event(s) in
the application event
>log on a number of my SQL servers. I have Googled this
and get the
>impression that it can just be ignored, but these are
becoming more
>frequent, and was wondering if anyone here could shed a
bit more light on
>the cause, and any possible way of preventing them. All
instances running
>SQL 2000 SP3 (or SP3a)
>Source: SQLSERVERAGENT
>Category: Alert Engine
>Event ID: 322
>Message: The data portion of event 19004 from MSSQLSERVER
is invalid.
>R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
(SQL2000)
>
>.
>|||Thanks for the response. I had already seen that KB article, but was
wondering if anyone had identified what causes this to start occurring. For
well over a year, I have not seen this message, then recently it started to
appear. I am leaning towards an upgrade by our ITS team of SMS 2000 to SMS
2003, and the application of the new SMS advanced client (not sure if SMS
uses SNMP to communicate with clients, and vice-versa). This seems to
roughly coincide with the start of these messages. In the meantime, I will
configure my monitoring software to stop alerting me of these messages.
Any thoughts?
R
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
> Its just a bug...
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;230393
> Peter
>
> >--Original Message--
> >Recently, I have been seeing the following event(s) in
> the application event
> >log on a number of my SQL servers. I have Googled this
> and get the
> >impression that it can just be ignored, but these are
> becoming more
> >frequent, and was wondering if anyone here could shed a
> bit more light on
> >the cause, and any possible way of preventing them. All
> instances running
> >SQL 2000 SP3 (or SP3a)
> >
> >Source: SQLSERVERAGENT
> >Category: Alert Engine
> >Event ID: 322
> >
> >Message: The data portion of event 19004 from MSSQLSERVER
> is invalid.
> >
> >R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
> (SQL2000)
> >
> >
> >.
> >|||The only thing I can think of is to go through the check
list below
http://www.microsoft.com/technet/prodtechnol/sms/sms2003/de
ploy/spgsms03/spsmsaph.mspx
Apologies for the lack of answers.
Peter
>--Original Message--
>Thanks for the response. I had already seen that KB
article, but was
>wondering if anyone had identified what causes this to
start occurring. For
>well over a year, I have not seen this message, then
recently it started to
>appear. I am leaning towards an upgrade by our ITS team
of SMS 2000 to SMS
>2003, and the application of the new SMS advanced client
(not sure if SMS
>uses SNMP to communicate with clients, and vice-versa).
This seems to
>roughly coincide with the start of these messages. In the
meantime, I will
>configure my monitoring software to stop alerting me of
these messages.
>Any thoughts?
>R
>"Peter the Spate" <anonymous@.discussions.microsoft.com>
wrote in message
>news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
>> Its just a bug...
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;230393
>> Peter
>>
>> >--Original Message--
>> >Recently, I have been seeing the following event(s) in
>> the application event
>> >log on a number of my SQL servers. I have Googled this
>> and get the
>> >impression that it can just be ignored, but these are
>> becoming more
>> >frequent, and was wondering if anyone here could shed a
>> bit more light on
>> >the cause, and any possible way of preventing them. All
>> instances running
>> >SQL 2000 SP3 (or SP3a)
>> >
>> >Source: SQLSERVERAGENT
>> >Category: Alert Engine
>> >Event ID: 322
>> >
>> >Message: The data portion of event 19004 from
MSSQLSERVER
>> is invalid.
>> >
>> >R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
>> (SQL2000)
>> >
>> >
>> >.
>> >
>
>.
>

Application Event log message

Its just a bug...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;230393
Peter

>--Original Message--
>Recently, I have been seeing the following event(s) in
the application event
>log on a number of my SQL servers. I have Googled this
and get the
>impression that it can just be ignored, but these are
becoming more
>frequent, and was wondering if anyone here could shed a
bit more light on
>the cause, and any possible way of preventing them. All
instances running
>SQL 2000 SP3 (or SP3a)
>Source: SQLSERVERAGENT
>Category: Alert Engine
>Event ID: 322
>Message: The data portion of event 19004 from MSSQLSERVER
is invalid.
>R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
(SQL2000)
>
>.
>
Thanks for the response. I had already seen that KB article, but was
wondering if anyone had identified what causes this to start occurring. For
well over a year, I have not seen this message, then recently it started to
appear. I am leaning towards an upgrade by our ITS team of SMS 2000 to SMS
2003, and the application of the new SMS advanced client (not sure if SMS
uses SNMP to communicate with clients, and vice-versa). This seems to
roughly coincide with the start of these messages. In the meantime, I will
configure my monitoring software to stop alerting me of these messages.
Any thoughts?
R
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...[vbcol=seagreen]
> Its just a bug...
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;230393
> Peter
>
> the application event
> and get the
> becoming more
> bit more light on
> instances running
> is invalid.
> (SQL2000)
|||The only thing I can think of is to go through the check
list below
http://www.microsoft.com/technet/pro...sms/sms2003/de
ploy/spgsms03/spsmsaph.mspx
Apologies for the lack of answers.
Peter

>--Original Message--
>Thanks for the response. I had already seen that KB
article, but was
>wondering if anyone had identified what causes this to
start occurring. For
>well over a year, I have not seen this message, then
recently it started to
>appear. I am leaning towards an upgrade by our ITS team
of SMS 2000 to SMS
>2003, and the application of the new SMS advanced client
(not sure if SMS
>uses SNMP to communicate with clients, and vice-versa).
This seems to
>roughly coincide with the start of these messages. In the
meantime, I will
>configure my monitoring software to stop alerting me of
these messages.
>Any thoughts?
>R
>"Peter the Spate" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
MSSQLSERVER
>
>.
>

Application Event log message

Its just a bug...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;230393
Peter

>--Original Message--
>Recently, I have been seeing the following event(s) in
the application event
>log on a number of my SQL servers. I have Googled this
and get the
>impression that it can just be ignored, but these are
becoming more
>frequent, and was wondering if anyone here could shed a
bit more light on
>the cause, and any possible way of preventing them. All
instances running
>SQL 2000 SP3 (or SP3a)
>Source: SQLSERVERAGENT
>Category: Alert Engine
>Event ID: 322
>Message: The data portion of event 19004 from MSSQLSERVER
is invalid.
>R - MCSE (2003, 2000, NT4), MCSA (2003, 2000), MCDBA
(SQL2000)
>
>.
>Thanks for the response. I had already seen that KB article, but was
wondering if anyone had identified what causes this to start occurring. For
well over a year, I have not seen this message, then recently it started to
appear. I am leaning towards an upgrade by our ITS team of SMS 2000 to SMS
2003, and the application of the new SMS advanced client (not sure if SMS
uses SNMP to communicate with clients, and vice-versa). This seems to
roughly coincide with the start of these messages. In the meantime, I will
configure my monitoring software to stop alerting me of these messages.
Any thoughts?
R
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...[vbcol=seagreen]
> Its just a bug...
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;230393
> Peter
>
> the application event
> and get the
> becoming more
> bit more light on
> instances running
> is invalid.
> (SQL2000)|||The only thing I can think of is to go through the check
list below
http://www.microsoft.com/technet/pr.../sms/sms2003/de
ploy/spgsms03/spsmsaph.mspx
Apologies for the lack of answers.
Peter

>--Original Message--
>Thanks for the response. I had already seen that KB
article, but was
>wondering if anyone had identified what causes this to
start occurring. For
>well over a year, I have not seen this message, then
recently it started to
>appear. I am leaning towards an upgrade by our ITS team
of SMS 2000 to SMS
>2003, and the application of the new SMS advanced client
(not sure if SMS
>uses SNMP to communicate with clients, and vice-versa).
This seems to
>roughly coincide with the start of these messages. In the
meantime, I will
>configure my monitoring software to stop alerting me of
these messages.
>Any thoughts?
>R
>"Peter the Spate" <anonymous@.discussions.microsoft.com>
wrote in message
>news:29be01c47df4$9064e4c0$a601280a@.phx.gbl...
MSSQLSERVER[vbcol=seagreen]
>
>.
>

Application Event ID 17177

I periodically get the following information from the
application event log:

quote:

---

>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).

---

Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...

quote:

---

> I periodically get the following information from the
> application event log:
>
> Why is this generated? What is the significance of this
> information?
>

---

|||We have a client who is getting the same error except it says a different pr
ocess id. The problem is it is showing up at 12:00 every night when sql ser
ver is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder.
When I view the dat files i
n the directory they are from November, needless to say not current. When I
am in the SQL enterprise manager under management- sql server agent-jobs, I
can see the separate jobs and when I look at the properties they are schedu
led for daily @. 12:00 am.
Why am I not getting updated files in the backup folder? Ntbackup is runni
ng nightly with no errors and is backing up all sql database files along wit
h this MSSQL\Backup folder but the files in it are not current. Ntbackup is
backing up to 4mmtape. An
y help guys would be greatly appreciated.
Phil

Application Event ID 17177

I periodically get the following information from the
application event log:
>This instance of SQL Server has been using a process id
>of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
>AM (UTC).
Why is this generated? What is the significance of this
information?This is an informational message and can be ignored.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gary Brunton" <gary_brunton@.hotmail.com> wrote in message
news:6b3001c3e6a0$238ee8f0$a001280a@.phx.gbl...
> I periodically get the following information from the
> application event log:
> >This instance of SQL Server has been using a process id
> >of 204 since 1/15/04 8:36:46 PM (local) 1/16/04 3:36:46
> >AM (UTC).
> Why is this generated? What is the significance of this
> information?
>|||We have a client who is getting the same error except it says a different process id. The problem is it is showing up at 12:00 every night when sql server is supposed to backup to the Microsoft SQL Server\MSSQL\Backup folder. When I view the dat files in the directory they are from November, needless to say not current. When I am in the SQL enterprise manager under management- sql server agent-jobs, I can see the separate jobs and when I look at the properties they are scheduled for daily @. 12:00 am. Why am I not getting updated files in the backup folder? Ntbackup is running nightly with no errors and is backing up all sql database files along with this MSSQL\Backup folder but the files in it are not current. Ntbackup is backing up to 4mmtape. Any help guys would be greatly appreciated
Phil

Application Event error

What could be causing this error in the event log?
SuperSocket info: Failed to get Exclusive port use(MSAFD
Tcpip [TCP/IP]) : Error 10013.It's often related to permissions for the SQL Server service
account. Have you made any changes to the service account
and what type of permissions does it have? I've seen the
error when people have changed the account but didn't do it
through Enterprise Manager or when they set up the account
to be more restrictive, not in the local admins (which is
fine) but didn't set all the correct rights and permissions.
-Sue
On Mon, 13 Oct 2003 08:52:32 -0700, "Jennifer Hennes"
<jennifer.hennes@.bartwest.com> wrote:
>What could be causing this error in the event log?
>SuperSocket info: Failed to get Exclusive port use(MSAFD
>Tcpip [TCP/IP]) : Error 10013.

append recordset returned from a stored procedure

I have a recordset returned from a stored procedure executed in the form open event. Could this recordset append to the form's recordsource property in the form's open event in VB? if so, what's the syntax?

Private Sub Form_Open(Cancel As Integer)
dim ...

Set add_bag_results = Nothing
With add_bag_results
.ActiveConnection = CurrentProject.Connection
.CommandType = adCmdStoredProc
.CommandText = "spSampling_add_bag_results"
.Parameters.Append .CreateParameter("ret_val", adInteger, adParamReturnValue)
'.Parameters.Append .CreateParameter("@.lotnum", adInteger, adParamInput, 4, rs_add_bag_results(1))
.Parameters.Append .CreateParameter("@.lotnum", adInteger, adParamInput, 4, lot_n)
..
Set rs_add_bag_results = .Execute
End With

Me.RecordSource = rs_add_bag_results ?

Thanks!I think this is a very insightfull question but your on the wrong forum for this I think. Try Extreme, VB.com, the response is just as quick and it's the same format as this forum. Frankly, I don't know vb but when I had to use it with asp.net I used Extreme vb forum for my code.|||Thanks for your reply. I did figured it out. You are right and I have posted my questions on vb extreme forum before. Thanks!

Apparent Security violations recorded in Event Viewer

I am receiving the following event in the event viewer. I
believe that it is from hackers trying to execute Sql
Statements against my Sql Server to gain access to my
website. I only have port 80 open via my firewall, so I'm
confused as to how they are getting in. Does anyone have
any suggestions?
Any help, ideas, suggestions would be greatly appreciated.
Pat Rogers
Event Type: Information
Event Source: ODBC Error (388221)
Event Category: None
Event ID: 0
Date: 7/21/2004
Time: 8:44:23 AM
User: N/A
Computer: P6-CR2-SVR
Description:
The description for Event ID ( 0 ) in Source ( ODBC Error
(388221) )
cannot be found. The local computer may not have the
necessary registry
information or message DLL files to display messages from
a remote
computer. The following information is part of the event:
Message Text:
=============
SQL Selected Record is invalid: - 00000.Pat,
I would at least make sure that you record all failed access attempts. This
can be done by properties - Security tab - Audit level and check Failure.
This way you can see who is trying to get access.
Chris Wood
Alberta Department of Energy
CANADA
"Pat Rogers" <progers@.kc.rr.com> wrote in message
news:2ea301c470e0$6a535d50$a401280a@.phx.gbl...
> I am receiving the following event in the event viewer. I
> believe that it is from hackers trying to execute Sql
> Statements against my Sql Server to gain access to my
> website. I only have port 80 open via my firewall, so I'm
> confused as to how they are getting in. Does anyone have
> any suggestions?
> Any help, ideas, suggestions would be greatly appreciated.
> Pat Rogers
> Event Type: Information
> Event Source: ODBC Error (388221)
> Event Category: None
> Event ID: 0
> Date: 7/21/2004
> Time: 8:44:23 AM
> User: N/A
> Computer: P6-CR2-SVR
> Description:
> The description for Event ID ( 0 ) in Source ( ODBC Error
> (388221) )
> cannot be found. The local computer may not have the
> necessary registry
> information or message DLL files to display messages from
> a remote
> computer. The following information is part of the event:
> Message Text:
> =============
> SQL Selected Record is invalid: - 00000.
>
>