Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Error in SQL Server Database

  
   Database Forums (Home) -> Client RSS
Next:  DB2 Development Center  
Author Message
mpaisignore

External


Since: Nov 18, 2004
Posts: 6



(Msg. 1) Posted: Thu Nov 18, 2004 2:40 pm
Post subject: Error in SQL Server Database
Archived from groups: microsoft>public>sqlserver>clients (more info?)
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: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

 >> Stay informed about: Error in SQL Server Database 
Back to top
Login to vote
David Gugick

External


Since: Sep 21, 2004
Posts: 147



(Msg. 2) Posted: Thu Nov 18, 2004 3:30 pm
Post subject: Re: Error in SQL Server Database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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: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

See if this thread helps (may require a login - which is free):
<a rel="nofollow" style='text-decoration: none;' href="http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=12331" target="_blank">http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=12331</a>





--
David Gugick
Imceda Software
<a rel="nofollow" style='text-decoration: none;' href="http://www.imceda.com" target="_blank">www.imceda.com</a>

 >> Stay informed about: Error in SQL Server Database 
Back to top
Login to vote
David Gugick

External


Since: Sep 21, 2004
Posts: 147



(Msg. 3) Posted: Thu Nov 18, 2004 3:36 pm
Post subject: Re: Error in SQL Server Database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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: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

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
<a rel="nofollow" style='text-decoration: none;' href="http://www.imceda.com" target="_blank">www.imceda.com</a>
 >> Stay informed about: Error in SQL Server Database 
Back to top
Login to vote
Deepak Janghela

External


Since: Mar 23, 2009
Posts: 1



(Msg. 4) Posted: Mon Mar 23, 2009 4:25 am
Post subject: RE: Error in SQL Server Database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Server: Msg 3624, Level 20, State 1, Line 1

Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447
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&rl...T4GZEZ_\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447+Expression:++m_SizeRec+>+0+&&+m_SizeRec+<=+MAXDATAROW+SPID:

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
 >> Stay informed about: Error in SQL Server Database 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Server 2005 Installation Error - --------------------------- Visual Studio Just-In-Time Debugger --------------------------- An unhandled win32 exception occurred in msiexec.exe [3484]. Just-In-Time debugging this exception failed with the following error: No installed debugger has..

Linked Server error in Windows2003Server - Dear all, I've got this error message on creating the linked server to the SQL Server 2000 (in Windows 2003 Server), "Error 18452: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." The client side is MSD...

SQL server Express client error - Hi! I have tried to setup my SQL Server Browser to Network mode but I keep getting an error saying "WMI Provider Error", "Can't add or remove a member of the local group because the member does not exist" Very strange error. What can ...

Server does not exist or access denied error - Hi, We have some applications that run on off of a Windows SQL Server database. The Database server was recently joined to a different domain. All of the users who have PC's on the new domain can logon fine, but we have one PC that is in a..

Error linked server query after installing SP4 on SQL 2000 - Hello SQL 2000 SP3a run fine with an linked server query like select * from openquery( linkedOlapServer, .. here is the MDX ...') After installing SP4 build 2039 this query fails with error: Server: Msg 7302, Level 16, State 1, Line 1 Could not create...
   Database Forums (Home) -> Client All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]