----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: scienty77 Message 1 in Discussion Hi All, Yesterday SQL Server tossed me up and down by giving connection broken error. And literally it has broken me. Here is the error detail, Server: Msg 3624, Level 20, State 1, Procedure Get_Report_Partnership_Info, Line 276 Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 51 Process ID: 1376 Connection Broken I tried searching over web and in Microsoft.com with the string highlighted in Red. Many articles guided me in various different directions. But couldnt solve the problem. First the error was detected while running a stored proc, that containes a cursor which fills a table. Since the format of data reqired was complex, we have to use cursor to acheive it. But when I checked today any query with a cursor has started giving the error. Can you please guide me what to do. I tried the following options 1. Installed SP3 for SQL 2. Tried with dbcc commands Could you please help me. Regards Raghu ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
