dbTalk Databases Forums  

Error in SQL Server Database

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Error in SQL Server Database in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marco Pais
 
Posts: n/a

Default Error in SQL Server Database - 11-18-2004 , 12:39 PM






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



Reply With Quote
  #2  
Old   
David Gugick
 
Posts: n/a

Default Re: Error in SQL Server Database - 11-18-2004 , 01:30 PM






Marco Pais wrote:
Quote:
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



Reply With Quote
  #3  
Old   
David Gugick
 
Posts: n/a

Default Re: Error in SQL Server Database - 11-18-2004 , 01:36 PM



Marco Pais wrote:
Quote:
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



Reply With Quote
  #4  
Old   
Deepak Janghela
 
Posts: n/a

Default RE: Error in SQL Server Database - 03-23-2009 , 02:05 AM



Server: Msg 3624, Level 20, State 1, Line 1

Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:14 47
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 51
Process ID: 412

Connection Broken


From http://www.google.co.in/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GZEZ_en-GBIN261IN261&q=Location:++q:\SPHINX\NTDBMS\storeng \drs\include\record.inl:1447+Expression:++m_SizeRe c+>+0+&&+m_SizeRec+<=+MAXDATAROW+SPID:

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.