Microsoft KB Archive/156257

= FIX: SQL Server May Crash When sp_who2 Is Debugged =

Article ID: 156257

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft Visual C++ 4.2 Enterprise Edition

-



This article was previously published under Q156257



SYMPTOMS
SQL Server may crash when the stored procedure sp_who2 in master database is debugged.



CAUSE
The sp_who2 stored procedure contains an EXECUTE string larger than 1024 characters. When it is debugged, SQL Server corrupts memory. This causes the server to crash anywhere from instantly to a few minutes.



RESOLUTION
Do not pass parameters to EXECute that are longer than 1024 characters.



STATUS
Microsoft has confirmed this to be an issue in the Microsoft products listed at the beginning of this article. This bug was corrected in Visual C++ version 5.0.



MORE INFORMATION
sp_who2 is a supplied stored procedure in the default master database. The problem occurs with any stored procedure or ODBC call that performs an EXECute with a parameter longer than 1024 characters. When the problem occurs, it can also cause the IDE to lock up, sometimes permanently.

A message can be written to the event log under MSDEVSDI that says, "Large batch command being debugged." The ID of the message is 13.

Additional query words: kbVC420bug

Keywords: kbbug kbfix kbsqlprog kbeedition kbvc500fix kbdebug KB156257

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.