Event Id : 17052

Hi,
Whenever a 17052 event from MSSQLServer source is generated, the
standard description we get is:
Error: 102, Severity: 22, State: 102
Configuration option 'allow updates' changed from 1 to 0. Run the
RECONFIGURE statement to install.
As far as I know, the range for error, severity and state is as below:
Error: 1-21695 (from sysmessages table)
Severity: 0-25
State: a value between 0-127
But everywhere I get this 17052 error message, I see the value of
State not more than 4.
Can I get a link where all the State codes are described?
Or is there any chance to get State code more than 4 in 17052 Event?
Please let me know.
Thanks in advance,
PIThe best source I know is for events that are not described well is
http://www.eventid.net/. Check for this event at
http://www.eventid.net/display.asp?eventid=17052&eventno=551&source=MSSQLServer&phase=1
if there is something interesting for you.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<ipramod@.gmail.com> wrote in message
news:1171432867.205759.306070@.s48g2000cws.googlegroups.com...
> Hi,
> Whenever a 17052 event from MSSQLServer source is generated, the
> standard description we get is:
> Error: 102, Severity: 22, State: 102
> Configuration option 'allow updates' changed from 1 to 0. Run the
> RECONFIGURE statement to install.
> As far as I know, the range for error, severity and state is as below:
> Error: 1-21695 (from sysmessages table)
> Severity: 0-25
> State: a value between 0-127
> But everywhere I get this 17052 error message, I see the value of
> State not more than 4.
> Can I get a link where all the State codes are described?
> Or is there any chance to get State code more than 4 in 17052 Event?
> Please let me know.
> Thanks in advance,
> PI
>|||Hi Dejan,
I have already gone through this links you provided. But I want to
know all state code that 17052 Event can receive.
Thanks for your reply.
PI
On Feb 14, 11:51 am, "Dejan Sarka"
<dejan_please_reply_to_newsgroups.sa...@.avtenta.si> wrote:
> The best source I know is for events that are not described well ishttp://www.eventid.net/. Check for this event athttp://www.eventid.net/display.asp?eventid=17052&eventno=551&source=M...
> if there is something interesting for you.
> --
> Dejan Sarkahttp://www.solidqualitylearning.com/blogs/
> <ipra...@.gmail.com> wrote in message
> news:1171432867.205759.306070@.s48g2000cws.googlegroups.com...
>
> > Hi,
> > Whenever a 17052 event from MSSQLServer source is generated, the
> > standard description we get is:
> > Error: 102, Severity: 22, State: 102
> > Configuration option 'allow updates' changed from 1 to 0. Run the
> > RECONFIGURE statement to install.
> > As far as I know, the range for error, severity and state is as below:
> > Error: 1-21695 (from sysmessages table)
> > Severity: 0-25
> > State: a value between 0-127
> > But everywhere I get this 17052 error message, I see the value of
> > State not more than 4.
> > Can I get a link where all the State codes are described?
> > Or is there any chance to get State code more than 4 in 17052 Event?
> > Please let me know.
> > Thanks in advance,
> > PI- Hide quoted text -
> - Show quoted text -