Error in SQL Server Database

Hello there,
I have a VB6 application that runs over a SQL Server 2000 Database.
Sometimes (most recently) i get the folowing error:
Run-time error -2147467259 (80004005)
Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:14 47
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 51
Process ID: 732
I have searched and read some posts in some forums, but I have no concret
solution.
Can any body help me? Thank you...
Regards,
Marco Pais
Marco Pais wrote:
> Hello there,
> I have a VB6 application that runs over a SQL Server 2000 Database.
> Sometimes (most recently) i get the folowing error:
> Run-time error -2147467259 (80004005)
> Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:14 47
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 51
> Process ID: 732
> I have searched and read some posts in some forums, but I have no
> concret solution.
> Can any body help me? Thank you...
> Regards,
> Marco Pais
See if this thread helps (may require a login - which is free):
http://www.sqlservercentral.com/foru...essageid=12331
David Gugick
Imceda Software
www.imceda.com
|||Marco Pais wrote:
> Hello there,
> I have a VB6 application that runs over a SQL Server 2000 Database.
> Sometimes (most recently) i get the folowing error:
> Run-time error -2147467259 (80004005)
> Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:14 47
> Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
> SPID: 51
> Process ID: 732
> I have searched and read some posts in some forums, but I have no
> concret solution.
> Can any body help me? Thank you...
> Regards,
> Marco Pais
BTW, that's an internal SQL Server error. You don't have a "q" drive.
Some others have corrected the problem by rebuilding the clustered index
on the affected table.
Run dbcc checkdb and dbcc checkalloc to see if any errors are reported.
If you can isolate the table, try rebuilding the clustered index.
It's probably some sort of data corruption, but could also be a disk
failure.
David Gugick
Imceda Software
www.imceda.com