Hi
While writing my latest report i have been trying to use the result of a
multi value parameter as the value for a "IN" expression in my SQL query,
this does not seem to work, the multi value parameter shows that it has
values in it but the "IN" expression wont use them to filter the SQL query.
I have since found that the way i am using the Parameter in the SQL is
correct but i am now unsure of how the parameter should be set up.
Can anyone help?
Steve D'IN' should have multiple values seperated with a comma. I hope you know
that. So you need to use =join() to build the multi value parameters into
something like this (1,2,3,4) then pass this value into the query it should
work.
Amarnath
"Steve Dearman" wrote:
> Hi
> While writing my latest report i have been trying to use the result of a
> multi value parameter as the value for a "IN" expression in my SQL query,
> this does not seem to work, the multi value parameter shows that it has
> values in it but the "IN" expression wont use them to filter the SQL query.
> I have since found that the way i am using the Parameter in the SQL is
> correct but i am now unsure of how the parameter should be set up.
> Can anyone help?
> Steve D
>
>|||When I use a multi-value parameter I just do this:
select somefield from sometable where anotherfield in (@.Param)
Where @.Param maps to a multi-value parameter. There is no need for anything
fancy unless passing the parameter to a stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:56A2A663-692A-460A-8D64-4FD1F1B0B80C@.microsoft.com...
> 'IN' should have multiple values seperated with a comma. I hope you know
> that. So you need to use =join() to build the multi value parameters into
> something like this (1,2,3,4) then pass this value into the query it
> should
> work.
> Amarnath
>
> "Steve Dearman" wrote:
>> Hi
>> While writing my latest report i have been trying to use the result of a
>> multi value parameter as the value for a "IN" expression in my SQL query,
>> this does not seem to work, the multi value parameter shows that it has
>> values in it but the "IN" expression wont use them to filter the SQL
>> query.
>> I have since found that the way i am using the Parameter in the SQL is
>> correct but i am now unsure of how the parameter should be set up.
>> Can anyone help?
>> Steve D
>>
Showing posts with label latest. Show all posts
Showing posts with label latest. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
MSSRS 2000 Restarts Windows XP system after the latest update
Hi Microsoft Sql server reproting services restarts the windows xp installed
desktops when we try to print using the print oprion in the report.
This is happening for lot of my clients.
How to fix this. This is happening only after the latest update in March.
My company has aroung 40,000 people who will be using the reports generated
by the reporting services most of them have windows xp with autometic update
switched on. Hence once the update happnes when they want to take a print out
of a report which shown using the MSSRS 2000 in internet explorere and
clicked onthe print icon in the report window system gets restarted.
Please help
Thanking you
SureshSuresh,
The first time you click the print icon a ActiveX control is installed. You
must have some sort of common desktop configuration that is blowing up when
you try to install this ActiveX.
First thing I would do is look at IE's security settings surrounding the
ActiveX downloading/installing.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> Hi Microsoft Sql server reproting services restarts the windows xp
> installed
> desktops when we try to print using the print oprion in the report.
> This is happening for lot of my clients.
> How to fix this. This is happening only after the latest update in March.
> My company has aroung 40,000 people who will be using the reports
> generated
> by the reporting services most of them have windows xp with autometic
> update
> switched on. Hence once the update happnes when they want to take a print
> out
> of a report which shown using the MSSRS 2000 in internet explorere and
> clicked onthe print icon in the report window system gets restarted.
> Please help
> Thanking you
> Suresh
>|||Thanks Andy.
But the issue is not with installing the active x.
In many systems the active x was installed long before.
It was working fine until recently a windws xp update was released.
After the update only when clicked on the print icon in the report displayed
in desktops the systems get restarted.
So this should be a bug introduced due to the recent update by Microsft
update for windows Xp. I am looking for a patch for this.
Regards
Suresh
"Andy Potter" wrote:
> Suresh,
> The first time you click the print icon a ActiveX control is installed. You
> must have some sort of common desktop configuration that is blowing up when
> you try to install this ActiveX.
> First thing I would do is look at IE's security settings surrounding the
> ActiveX downloading/installing.
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
> news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > Hi Microsoft Sql server reproting services restarts the windows xp
> > installed
> > desktops when we try to print using the print oprion in the report.
> >
> > This is happening for lot of my clients.
> > How to fix this. This is happening only after the latest update in March.
> >
> > My company has aroung 40,000 people who will be using the reports
> > generated
> > by the reporting services most of them have windows xp with autometic
> > update
> > switched on. Hence once the update happnes when they want to take a print
> > out
> > of a report which shown using the MSSRS 2000 in internet explorere and
> > clicked onthe print icon in the report window system gets restarted.
> >
> > Please help
> > Thanking you
> > Suresh
> >
> >
>
>|||Suresh,
We are facing the same problem..
I was searching around when i got something on this issue in the below
URL.
Not sure to what extent it will identify and solve this problem, but
may be worth a read.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
Please let us know if any body gets some solution to this
On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> Thanks Andy.
> But the issue is not with installing the active x.
> In many systems the active x was installed long before.
> It was working fine until recently a windws xp update was released.
> After the update only when clicked on theprinticon in the report displayed
> in desktops the systems get restarted.
> So this should be a bug introduced due to the recent update by Microsft
> update for windows Xp. I am looking for a patch for this.
> Regards
> Suresh
>
> "Andy Potter" wrote:
> > Suresh,
> > The first time you click theprinticon a ActiveX control is installed. You
> > must have some sort of common desktop configuration that is blowing up when
> > you try to install this ActiveX.
> > First thing I would do is look at IE's security settings surrounding the
> > ActiveX downloading/installing.
> > --
> > Andy Potter
> > blog :http://sqlreportingservices.spaces.live.com
> > info@.(NOSPAM)lakeclaireenterprises.com
> > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > installed
> > > desktops when we try toprintusing theprintoprion in the report.
> > > This is happening for lot of my clients.
> > > How to fix this. This is happening only after the latest update in March.
> > > My company has aroung 40,000 people who will be using the reports
> > > generated
> > > by thereporting servicesmost of them have windows xp with autometic
> > > update
> > > switched on. Hence once the update happnes when they want to take aprint
> > > out
> > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > clicked ontheprinticon in the report windowsystemgets restarted.
> > > Please help
> > > Thanking you
> > > Suresh- Hide quoted text -
> - Show quoted text -|||Hi Shocky,
It is really great. the link you have given actually solved my problem.
Thanks a lot for the help. This was the need of the hour for me.
Once again
Thanking you
Suresh
"Shocky" wrote:
> Suresh,
> We are facing the same problem..
> I was searching around when i got something on this issue in the below
> URL.
> Not sure to what extent it will identify and solve this problem, but
> may be worth a read.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
>
> Please let us know if any body gets some solution to this
>
> On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> > Thanks Andy.
> >
> > But the issue is not with installing the active x.
> >
> > In many systems the active x was installed long before.
> > It was working fine until recently a windws xp update was released.
> > After the update only when clicked on theprinticon in the report displayed
> > in desktops the systems get restarted.
> >
> > So this should be a bug introduced due to the recent update by Microsft
> > update for windows Xp. I am looking for a patch for this.
> >
> > Regards
> > Suresh
> >
> >
> >
> > "Andy Potter" wrote:
> > > Suresh,
> >
> > > The first time you click theprinticon a ActiveX control is installed. You
> > > must have some sort of common desktop configuration that is blowing up when
> > > you try to install this ActiveX.
> >
> > > First thing I would do is look at IE's security settings surrounding the
> > > ActiveX downloading/installing.
> >
> > > --
> > > Andy Potter
> > > blog :http://sqlreportingservices.spaces.live.com
> > > info@.(NOSPAM)lakeclaireenterprises.com
> > > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> > >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > > installed
> > > > desktops when we try toprintusing theprintoprion in the report.
> >
> > > > This is happening for lot of my clients.
> > > > How to fix this. This is happening only after the latest update in March.
> >
> > > > My company has aroung 40,000 people who will be using the reports
> > > > generated
> > > > by thereporting servicesmost of them have windows xp with autometic
> > > > update
> > > > switched on. Hence once the update happnes when they want to take aprint
> > > > out
> > > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > > clicked ontheprinticon in the report windowsystemgets restarted.
> >
> > > > Please help
> > > > Thanking you
> > > > Suresh- Hide quoted text -
> >
> > - Show quoted text -
>
>sql
desktops when we try to print using the print oprion in the report.
This is happening for lot of my clients.
How to fix this. This is happening only after the latest update in March.
My company has aroung 40,000 people who will be using the reports generated
by the reporting services most of them have windows xp with autometic update
switched on. Hence once the update happnes when they want to take a print out
of a report which shown using the MSSRS 2000 in internet explorere and
clicked onthe print icon in the report window system gets restarted.
Please help
Thanking you
SureshSuresh,
The first time you click the print icon a ActiveX control is installed. You
must have some sort of common desktop configuration that is blowing up when
you try to install this ActiveX.
First thing I would do is look at IE's security settings surrounding the
ActiveX downloading/installing.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> Hi Microsoft Sql server reproting services restarts the windows xp
> installed
> desktops when we try to print using the print oprion in the report.
> This is happening for lot of my clients.
> How to fix this. This is happening only after the latest update in March.
> My company has aroung 40,000 people who will be using the reports
> generated
> by the reporting services most of them have windows xp with autometic
> update
> switched on. Hence once the update happnes when they want to take a print
> out
> of a report which shown using the MSSRS 2000 in internet explorere and
> clicked onthe print icon in the report window system gets restarted.
> Please help
> Thanking you
> Suresh
>|||Thanks Andy.
But the issue is not with installing the active x.
In many systems the active x was installed long before.
It was working fine until recently a windws xp update was released.
After the update only when clicked on the print icon in the report displayed
in desktops the systems get restarted.
So this should be a bug introduced due to the recent update by Microsft
update for windows Xp. I am looking for a patch for this.
Regards
Suresh
"Andy Potter" wrote:
> Suresh,
> The first time you click the print icon a ActiveX control is installed. You
> must have some sort of common desktop configuration that is blowing up when
> you try to install this ActiveX.
> First thing I would do is look at IE's security settings surrounding the
> ActiveX downloading/installing.
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
> news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > Hi Microsoft Sql server reproting services restarts the windows xp
> > installed
> > desktops when we try to print using the print oprion in the report.
> >
> > This is happening for lot of my clients.
> > How to fix this. This is happening only after the latest update in March.
> >
> > My company has aroung 40,000 people who will be using the reports
> > generated
> > by the reporting services most of them have windows xp with autometic
> > update
> > switched on. Hence once the update happnes when they want to take a print
> > out
> > of a report which shown using the MSSRS 2000 in internet explorere and
> > clicked onthe print icon in the report window system gets restarted.
> >
> > Please help
> > Thanking you
> > Suresh
> >
> >
>
>|||Suresh,
We are facing the same problem..
I was searching around when i got something on this issue in the below
URL.
Not sure to what extent it will identify and solve this problem, but
may be worth a read.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
Please let us know if any body gets some solution to this
On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> Thanks Andy.
> But the issue is not with installing the active x.
> In many systems the active x was installed long before.
> It was working fine until recently a windws xp update was released.
> After the update only when clicked on theprinticon in the report displayed
> in desktops the systems get restarted.
> So this should be a bug introduced due to the recent update by Microsft
> update for windows Xp. I am looking for a patch for this.
> Regards
> Suresh
>
> "Andy Potter" wrote:
> > Suresh,
> > The first time you click theprinticon a ActiveX control is installed. You
> > must have some sort of common desktop configuration that is blowing up when
> > you try to install this ActiveX.
> > First thing I would do is look at IE's security settings surrounding the
> > ActiveX downloading/installing.
> > --
> > Andy Potter
> > blog :http://sqlreportingservices.spaces.live.com
> > info@.(NOSPAM)lakeclaireenterprises.com
> > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > installed
> > > desktops when we try toprintusing theprintoprion in the report.
> > > This is happening for lot of my clients.
> > > How to fix this. This is happening only after the latest update in March.
> > > My company has aroung 40,000 people who will be using the reports
> > > generated
> > > by thereporting servicesmost of them have windows xp with autometic
> > > update
> > > switched on. Hence once the update happnes when they want to take aprint
> > > out
> > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > clicked ontheprinticon in the report windowsystemgets restarted.
> > > Please help
> > > Thanking you
> > > Suresh- Hide quoted text -
> - Show quoted text -|||Hi Shocky,
It is really great. the link you have given actually solved my problem.
Thanks a lot for the help. This was the need of the hour for me.
Once again
Thanking you
Suresh
"Shocky" wrote:
> Suresh,
> We are facing the same problem..
> I was searching around when i got something on this issue in the below
> URL.
> Not sure to what extent it will identify and solve this problem, but
> may be worth a read.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
>
> Please let us know if any body gets some solution to this
>
> On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> > Thanks Andy.
> >
> > But the issue is not with installing the active x.
> >
> > In many systems the active x was installed long before.
> > It was working fine until recently a windws xp update was released.
> > After the update only when clicked on theprinticon in the report displayed
> > in desktops the systems get restarted.
> >
> > So this should be a bug introduced due to the recent update by Microsft
> > update for windows Xp. I am looking for a patch for this.
> >
> > Regards
> > Suresh
> >
> >
> >
> > "Andy Potter" wrote:
> > > Suresh,
> >
> > > The first time you click theprinticon a ActiveX control is installed. You
> > > must have some sort of common desktop configuration that is blowing up when
> > > you try to install this ActiveX.
> >
> > > First thing I would do is look at IE's security settings surrounding the
> > > ActiveX downloading/installing.
> >
> > > --
> > > Andy Potter
> > > blog :http://sqlreportingservices.spaces.live.com
> > > info@.(NOSPAM)lakeclaireenterprises.com
> > > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> > >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > > installed
> > > > desktops when we try toprintusing theprintoprion in the report.
> >
> > > > This is happening for lot of my clients.
> > > > How to fix this. This is happening only after the latest update in March.
> >
> > > > My company has aroung 40,000 people who will be using the reports
> > > > generated
> > > > by thereporting servicesmost of them have windows xp with autometic
> > > > update
> > > > switched on. Hence once the update happnes when they want to take aprint
> > > > out
> > > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > > clicked ontheprinticon in the report windowsystemgets restarted.
> >
> > > > Please help
> > > > Thanking you
> > > > Suresh- Hide quoted text -
> >
> > - Show quoted text -
>
>sql
Monday, March 12, 2012
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
>>
>>
>
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
>>
>>
>
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...
> 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...
>
|||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...
>
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...
> 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...
>
|||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...
>
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...
> 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...
>|||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...
>
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...
> 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...
>|||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...
>
Subscribe to:
Posts (Atom)