MSSQLSERVER errors on PC running MSDE

I have a retail account with 2 PC's running the latest version of
Microsofts RMS. One of the PC's
acts as the server using MSDE. In the event viewer for this PC there are
hundreds of
errors that show this:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 11/25/2004
Time: 2:55:04 AM
User: N/A
Computer: W_CM1
Description:
Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '160000019f9af100' in index page
(1:28465), index ID 0, database 'conrevhb2'.
Data:
0000: 84 02 00 00 15 00 00 00 ?......
0008: 06 00 00 00 57 00 5f 00 ...W._.
0010: 43 00 4d 00 31 00 00 00 C.M.1...
0018: 0a 00 00 00 63 00 6f 00 ...c.o.
0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
0028: 68 00 62 00 32 00 00 00 h.b.2...
Can someone help me out?
Thanks
John"John" <jk@.rt.com> wrote in message
news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>I have a retail account with 2 PC's running the latest version of
>Microsofts RMS. One of the PC's
> acts as the server using MSDE. In the event viewer for this PC there are
> hundreds of
> errors that show this:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 11/25/2004
> Time: 2:55:04 AM
> User: N/A
> Computer: W_CM1
> Description:
> Error: 644, Severity: 21, State: 3
> Could not find the index entry for RID '160000019f9af100' in index page
> (1:28465), index ID 0, database 'conrevhb2'.
> Data:
> 0000: 84 02 00 00 15 00 00 00 ?......
> 0008: 06 00 00 00 57 00 5f 00 ...W._.
> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
> 0028: 68 00 62 00 32 00 00 00 h.b.2...
> Can someone help me out?
> Thanks
> John
>
>
Your clustered index on database conrevhb2 has problems with it. Take a
look at the BOL for DBCC CHECKDB command. There are some repair options.
If that doesn't work, you may need to drop and recreate your clustered
index. (Keep in mind that it may be your Primary key constraint as well, as
this automatically creates a clustered index by default.).
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for the reply but, I am not a database admin so I know I can do a
google search and see what you are suggesting but is this correct for a
database using the MSDE engineon a Win2K Pro machine?
TIA
John
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
> "John" <jk@.rt.com> wrote in message
> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there are
>> hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
> Your clustered index on database conrevhb2 has problems with it. Take a
> look at the BOL for DBCC CHECKDB command. There are some repair options.
> If that doesn't work, you may need to drop and recreate your clustered
> index. (Keep in mind that it may be your Primary key constraint as well,
> as this automatically creates a clustered index by default.).
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>|||MSDE uses the same DLLs that SQL Server uses. It has certain built-in
limitations on how it operates, but this is essentially what needs to be
fixed.
If you don't have Query Analzer, you may try to use osql and do this work
from the command line.
Rick
"John" <jk@.rt.com> wrote in message
news:ec$IJyi1EHA.3596@.TK2MSFTNGP12.phx.gbl...
> Rick,
> Thanks for the reply but, I am not a database admin so I know I can do a
> google search and see what you are suggesting but is this correct for a
> database using the MSDE engineon a Win2K Pro machine?
> TIA
>
> John
>
> "Rick Sawtell" <quickening@.msn.com> wrote in message
> news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
>> "John" <jk@.rt.com> wrote in message
>> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there
>> are hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
>>
>> Your clustered index on database conrevhb2 has problems with it. Take a
>> look at the BOL for DBCC CHECKDB command. There are some repair options.
>> If that doesn't work, you may need to drop and recreate your clustered
>> index. (Keep in mind that it may be your Primary key constraint as well,
>> as this automatically creates a clustered index by default.).
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>|||Thanks Rick!!
John
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23xY1J%23i1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> MSDE uses the same DLLs that SQL Server uses. It has certain built-in
> limitations on how it operates, but this is essentially what needs to be
> fixed.
> If you don't have Query Analzer, you may try to use osql and do this work
> from the command line.
> Rick
>
> "John" <jk@.rt.com> wrote in message
> news:ec$IJyi1EHA.3596@.TK2MSFTNGP12.phx.gbl...
>> Rick,
>> Thanks for the reply but, I am not a database admin so I know I can do a
>> google search and see what you are suggesting but is this correct for a
>> database using the MSDE engineon a Win2K Pro machine?
>> TIA
>>
>> John
>>
>> "Rick Sawtell" <quickening@.msn.com> wrote in message
>> news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
>> "John" <jk@.rt.com> wrote in message
>> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there
>> are hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
>>
>> Your clustered index on database conrevhb2 has problems with it. Take a
>> look at the BOL for DBCC CHECKDB command. There are some repair
>> options. If that doesn't work, you may need to drop and recreate your
>> clustered index. (Keep in mind that it may be your Primary key
>> constraint as well, as this automatically creates a clustered index by
>> default.).
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>