FIX: SQL Server May Crash When sp_who2 Is Debugged

• Microsoft Visual C++, 32-bit Enterprise Edition, version 4.2

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 : kbDebug kbEEdition kbSQL kbVC kbVC500fix
Version : WINDOWS:4.2
Platform : WINDOWS
Issue type : kbbug