Server: Msg 3624 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Server: Msg 3624

Author

Topic

korosh
Starting Member

3 Posts

Posted - 2007-11-17 : 08:06:53

when I run (select * from product )from QueryAnalizer this message appear what should I do?

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

Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 62
Process ID: 1484

Connection Broken

I need your help anywhere

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-17 : 21:17:33

Try run it on sql server directly.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-17 : 21:26:55

If SQL Server 2000 and not SP4 make sure it's not this bug: http://support.microsoft.com/kb/827714 , if it is apply the SP (you should apply it anyway if you don't have it).

Future guru in the making.

korosh
Starting Member

3 Posts

Posted - 2007-11-18 : 03:02:36

it is SQL Server 2000 with SP3 and I Delete primary key on table PRODUCT to rebuild Clustered index on it but the result was the same. also I couldn't make primary key again.I'm running queries directly from Server.

I need your help anywhere

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-18 : 11:02:36

I would apply SP4, there were multiple fixes in this area http://support.microsoft.com/kb/317852

Future guru in the making.

korosh
Starting Member

3 Posts

Posted - 2007-11-19 : 02:59:20

I apply SP4 , and it seems working good.thanks for your kindness.

I need your help anywhere,anytime

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-19 : 09:48:53