Error: 3624, Severity: 20 - 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

SQL Server 2000 Forums

SQL Server Administration (2000)

Error: 3624, Severity: 20

Author

Topic

izaltsman
A custom title

1139 Posts

Posted - 2002-07-26 : 16:42:40

Hello, all!

Has anyone seen this error before:

Error: 3624, Severity: 20, State: 1.
SQL Server Assertion: File: <recbase.cpp>, line=1374
Failed Assertion = 'm_nVars > 0'.

(SQL2k SP2 on Win2k Advanced Server)

Argyle
Yak Posting Veteran

53 Posts

Posted - 2002-07-26 : 19:13:14

A search on http://groups.google.com on the error message leads you to the following thread:

http://groups.google.com/groups?hl=sv&lr=&ie=UTF-8&oe=UTF-8&threadm=uFaMy4bpBHA.2564%40tkmsftngp04&rnum=4&prev=/groups%3Fhl%3Dsv%26ie%3DUTF-8%26oe%3DUTF-8%26q%3DError%2B3624%2BSeverity%2B20%2BState%2B1%2Brecbase.cpp%26sa%3DN%26tab%3Dwg%26lr%3D

Seems to be a reproducable bug in SQL 2000. The thread is from january so check with Microsoft if a post-SP2 hotfix exist.

If the above thread doesn't help, check for *.dmp files on your SQL server and call Microsoft support.

/Argyle

izaltsman
A custom title

1139 Posts

Posted - 2002-07-29 : 17:02:46

Thanks a lot for the link!
Not sure it applies in my case though. The stored proc that caused this error does a million different things, but it does not add any fields to any tables.
I haven't seen this error since it happened last week. I'll see if I can reproduce this error before I report it to Microsoft.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources