Error when rebuild table index

I ran maintenance plan trying to rebuild index for the database tables, and I
got following error.
[22] Database CmpData: Index Rebuild (leaving 10%% free space)...
Rebuilding indexes for table 'cliStores'
Rebuilding indexes for table 'cmpItems'
Rebuilding indexes for table 'cmpStores'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
I run following set command.
SET ANSI_DEFAULTS ON
But error remains. Please help. Thanks,
Charts
Sounds like you have a computed column in the table. The maintenance wizard
can not properly handle those. If you have SP4 then try this:
http://support.microsoft.com/?kbid=902388
Otherwise the solution is to create your own scheduled job that issues a
DBCC DBREINDEX for that table (or all of them) and set the proper SET
settings there.
Andrew J. Kelly SQL MVP
"Charts" <Acharts@.newsgroup.nospam> wrote in message
news:6752D209-A390-44C7-95EC-28B2B6BBF135@.microsoft.com...
>I ran maintenance plan trying to rebuild index for the database tables, and
>I
> got following error.
> [22] Database CmpData: Index Rebuild (leaving 10%% free space)...
> Rebuilding indexes for table 'cliStores'
> Rebuilding indexes for table 'cmpItems'
> Rebuilding indexes for table 'cmpStores'
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]DBCC failed because the following SET options
> have
> incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> I run following set command.
> SET ANSI_DEFAULTS ON
> But error remains. Please help. Thanks,
> Charts
>
|||Hi Andrew,
You are right, and The table has a computed column. Since my SQL Server is
SP4. I followed the instruction in the article and added -CkDB
-SupportComputedColumn' in the job command. The job command is as follows.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
Server\myservername\LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 -CkDB
-SupportComputedColumn'
Now I got another error, and says.
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC
SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][Shared
Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
The original command is as follows.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
Server\ myservername \LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '
By the way, is there way to directly add SupportComputedColumn' parameter in
the property of maintenance plan wizard instead of command line?
Thanks for your help.
Charts
"Andrew J. Kelly" wrote:

> Sounds like you have a computed column in the table. The maintenance wizard
> can not properly handle those. If you have SP4 then try this:
> http://support.microsoft.com/?kbid=902388
> Otherwise the solution is to create your own scheduled job that issues a
> DBCC DBREINDEX for that table (or all of them) and set the proper SET
> settings there.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Charts" <Acharts@.newsgroup.nospam> wrote in message
> news:6752D209-A390-44C7-95EC-28B2B6BBF135@.microsoft.com...
>
>
|||I really don't know why you are getting the new error. There is no way to
embed it that I know of. Personally I never recommend the MP wizard. My
recommendation is to simply create your own job that does the reindexing the
way you need it.
Andrew J. Kelly SQL MVP
"Charts" <Acharts@.newsgroup.nospam> wrote in message
news:3E936E12-AA09-4880-BEB1-8F0CA5BE613B@.microsoft.com...[vbcol=seagreen]
> Hi Andrew,
> You are right, and The table has a computed column. Since my SQL Server is
> SP4. I followed the instruction in the article and added -CkDB
> -SupportComputedColumn' in the job command. The job command is as
> follows.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
> Server\myservername\LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
> 4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 -CkDB
> -SupportComputedColumn'
> Now I got another error, and says.
> Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC
> SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][Shared
> Memory]SQL Server does not exist or access denied.
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (Connect()).
> The original command is as follows.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
> Server\ myservername \LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
> 4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '
> By the way, is there way to directly add SupportComputedColumn' parameter
> in
> the property of maintenance plan wizard instead of command line?
> Thanks for your help.
> Charts
>
> "Andrew J. Kelly" wrote:
|||Charts,
I have the EXACT same problem.. computed column and use of
-SupportComputedColumn is causing ODBC connection issues. Have you
found any resolution? I have been unable to find any help anywhere
including BOL, MSKB etc...
Thanks in advance.
MJM
Charts wrote:[vbcol=seagreen]
> Hi Andrew,
> You are right, and The table has a computed column. Since my SQL Server is
> SP4. I followed the instruction in the article and added -CkDB
> -SupportComputedColumn' in the job command. The job command is as follows.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
> Server\myservername\LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
> 4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 -CkDB
> -SupportComputedColumn'
> Now I got another error, and says.
> Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC
> SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][Shared
> Memory]SQL Server does not exist or access denied.
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
> The original command is as follows.
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> AC13D3D2-F803-49E4-A562-2B4C25B7C77D -Rpt "C:\Program Files\Microsoft SQL
> Server\ myservername \LOG\DB Maintenance Plan-correction0.txt" -DelTxtRpt
> 4WEEKS -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '
> By the way, is there way to directly add SupportComputedColumn' parameter in
> the property of maintenance plan wizard instead of command line?
> Thanks for your help.
> Charts
>
> "Andrew J. Kelly" wrote:
|||I have found that the SP4 option -SupportComputedColumn only works on a
default instance not a named instance. I'm contacting MS to see if
that can be supported.
Andrew J. Kelly wrote:[vbcol=seagreen]
> I really don't know why you are getting the new error. There is no way to
> embed it that I know of. Personally I never recommend the MP wizard. My
> recommendation is to simply create your own job that does the reindexing the
> way you need it.
> --
> Andrew J. Kelly SQL MVP
>
> "Charts" <Acharts@.newsgroup.nospam> wrote in message
> news:3E936E12-AA09-4880-BEB1-8F0CA5BE613B@.microsoft.com...

error when exporting to excel

Hi,
When I export my resport to excel in reprot manager.
It always results in an error: index is out of bounds.
How can I do that?A few questions:
Are you using SQL Server 2000 Reporting Services 2000 SP1?
What is the exact error you are receiving?
Are you using an image in a page header?
Can you reproduce the problem using a sample database? If so could you post
an RDL the demonstrates the problem?
If you cannot not reproduce the problem with sample data is it possible for
you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
of SP1
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When I export my resport to excel in reprot manager.
> It always results in an error: index is out of bounds.
> How can I do that?
>|||Thank Sir,
1. Yes, I have upgrade to SP1.
2. I am using Trandition Chinese version. The error is about index out of
bound or below zero.
3. Yes, I have two images in the page header.
4. I use Office xp. Is the problem is related to the version of Excel?
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> A few questions:
> Are you using SQL Server 2000 Reporting Services 2000 SP1?
> What is the exact error you are receiving?
> Are you using an image in a page header?
> Can you reproduce the problem using a sample database? If so could you
post
> an RDL the demonstrates the problem?
> If you cannot not reproduce the problem with sample data is it possible
for
> you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
> of SP1
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > When I export my resport to excel in reprot manager.
> > It always results in an error: index is out of bounds.
> > How can I do that?
> >
> >
>|||An "index was out of range" error will occur under the following conditions:
* SP1 is being used
* A page header contains an image
* The report is exported to excel.
The full error is "Index was out of range. Must be non-negative and less
than the size of the collection. Parameter name: index".
There are two workarounds for this issue:
* Increase the size of the page header so it is greater than the image
height.
* Set the image sizing property to "Fit"
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> Thank Sir,
> 1. Yes, I have upgrade to SP1.
> 2. I am using Trandition Chinese version. The error is about index out of
> bound or below zero.
> 3. Yes, I have two images in the page header.
> 4. I use Office xp. Is the problem is related to the version of Excel?
>
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > A few questions:
> >
> > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > What is the exact error you are receiving?
> > Are you using an image in a page header?
> > Can you reproduce the problem using a sample database? If so could you
> post
> > an RDL the demonstrates the problem?
> > If you cannot not reproduce the problem with sample data is it possible
> for
> > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
part
> > of SP1
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > When I export my resport to excel in reprot manager.
> > > It always results in an error: index is out of bounds.
> > > How can I do that?
> > >
> > >
> >
> >
>|||Thank's Sir
Your answer is excellent!
After I increased the size of the page header, it's OK
Thank a lot
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:e8oJ3PclEHA.3988@.tk2msftngp13.phx.gbl...
> An "index was out of range" error will occur under the following
conditions:
> * SP1 is being used
> * A page header contains an image
> * The report is exported to excel.
> The full error is "Index was out of range. Must be non-negative and less
> than the size of the collection. Parameter name: index".
> There are two workarounds for this issue:
> * Increase the size of the page header so it is greater than the image
> height.
> * Set the image sizing property to "Fit"
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> > Thank Sir,
> > 1. Yes, I have upgrade to SP1.
> > 2. I am using Trandition Chinese version. The error is about index out
of
> > bound or below zero.
> > 3. Yes, I have two images in the page header.
> > 4. I use Office xp. Is the problem is related to the version of Excel?
> >
> >
> >
> >
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> > :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > A few questions:
> > >
> > > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > > What is the exact error you are receiving?
> > > Are you using an image in a page header?
> > > Can you reproduce the problem using a sample database? If so could you
> > post
> > > an RDL the demonstrates the problem?
> > > If you cannot not reproduce the problem with sample data is it
possible
> > for
> > > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
> part
> > > of SP1
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > > When I export my resport to excel in reprot manager.
> > > > It always results in an error: index is out of bounds.
> > > > How can I do that?
> > > >
> > > >
> > >
> > >
> >
> >
>sql

Error SQL 7.0

Hi,
I got this error in the error log:
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in the page header = (0:0).
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF..
2
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the page header = (0:0).
Does anyone can tell me what that it means? Or if it is important and the way to solve
The engine has not service packs intalled
Thanks in advance
this is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
http://msdn.microsoft.com/library/de...err_1_2a0j.asp
more articles.
http://search.microsoft.com/search/r...u=Error%3a+823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =
(0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance
|||I suggest you download and install the latest update for SQL Server 2000 Books Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but these things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the way to solve
> The engine has not service packs intalled
> Thanks in advance

Error SQL 7.0

Hi
I got this error in the error log
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in the page header = (0:0)
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State:
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF.
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the page header = (0:0)
Does anyone can tell me what that it means? Or if it is important and the way to solv
The engine has not service packs intalle
Thanks in advancethis is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_2a0j.asp
more articles.
http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=Error%3a+823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =(0x1:0x1063b7), dbid = 9, status = 0x801, file =e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance|||I suggest you download and install the latest update for SQL Server 2000 Books Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but these things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file =e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the way to solve
> The engine has not service packs intalled
> Thanks in advance

Error SQL 7.0

Hi,
I got this error in the error log:
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:1074103). The PageId in the page header = (0:0).
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read
of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7)
, dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF..
2
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID
(1:76799). The PageId in the page header = (0:0).
Does anyone can tell me what that it means? Or if it is important and the wa
y to solve
The engine has not service packs intalled
Thanks in advancethis is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
serr_1_2a0j.asp" target="_blank">http://msdn.microsoft.com/library/d...serr_1_2a0j.asp
more articles.
823" target="_blank">http://search.microsoft.com/search/...%3a+
823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =
(0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance|||I suggest you download and install the latest update for SQL Server 2000 Boo
ks Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but th
ese things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1
:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BU
F pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, fi
le =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76
799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance