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
Showing posts with label errorrun-time. Show all posts
Showing posts with label errorrun-time. Show all posts
Wednesday, March 21, 2012
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
This could be a bug in SQL Server or a corruption caused by hardware.
Please first use "DBCC CHECKDB" to see if your database has any corruptions.
Please also check the windows event log for any suspicious hardware error.
You can then contact Microsoft SQL Server product support if you suspect
this to be a SQL Server bug.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:utzyb4ZzEHA.1196@.TK2MSFTNGP15.phx.gbl...
> 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
>
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
This could be a bug in SQL Server or a corruption caused by hardware.
Please first use "DBCC CHECKDB" to see if your database has any corruptions.
Please also check the windows event log for any suspicious hardware error.
You can then contact Microsoft SQL Server product support if you suspect
this to be a SQL Server bug.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:utzyb4ZzEHA.1196@.TK2MSFTNGP15.phx.gbl...
> 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
>
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
The following is an article with the exact same error:
http://support.microsoft.com/default...b;en-us;827714
Do those conditions apply in your case?
What exactly is the application doing when you get the
error? What T-SQL is being executed?
-Sue
On Thu, 18 Nov 2004 18:39:53 -0000, "Marco Pais"
<mpaisIGNORE@.foruminformatica.pt> 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
>
sql
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
The following is an article with the exact same error:
http://support.microsoft.com/default...b;en-us;827714
Do those conditions apply in your case?
What exactly is the application doing when you get the
error? What T-SQL is being executed?
-Sue
On Thu, 18 Nov 2004 18:39:53 -0000, "Marco Pais"
<mpaisIGNORE@.foruminformatica.pt> 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
>
sql
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\rec
ord.inl:1447
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 PaisThis could be a bug in SQL Server or a corruption caused by hardware.
Please first use "DBCC CHECKDB" to see if your database has any corruptions.
Please also check the windows event log for any suspicious hardware error.
You can then contact Microsoft SQL Server product support if you suspect
this to be a SQL Server bug.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:utzyb4ZzEHA.1196@.TK2MSFTNGP15.phx.gbl...
> 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\rec
ord.inl:1447
> 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
>
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\rec
ord.inl:1447
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 PaisThis could be a bug in SQL Server or a corruption caused by hardware.
Please first use "DBCC CHECKDB" to see if your database has any corruptions.
Please also check the windows event log for any suspicious hardware error.
You can then contact Microsoft SQL Server product support if you suspect
this to be a SQL Server bug.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:utzyb4ZzEHA.1196@.TK2MSFTNGP15.phx.gbl...
> 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\rec
ord.inl:1447
> 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
>
Subscribe to:
Posts (Atom)