Single-stepping through a SQL Server stored procedure does not display error messages at the point where the errors occur in Visual C++

This article was previously published under Q155716
This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
When single-stepping through a SQL Server stored procedure, error messages, if generated, are not displayed at the point where the error occurred.
STATUS
We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
To reproduce this behavior, create and single-step through the following stored procedure in the SQL Server Pubs sample database:
------------------------------CREATE PROCEDURE sp_trigger ASINSERT authors    VALUES ('123-21-2321', 'Redmond', 'Ricky', '206/555-1212',          '123 Nowhere St.', 'Redmond', 'WA', '98989', DEFAULT )DECLARE @a INTEGERSELECT @a = 4/2RETURN------------------------------				
The INSERT statement fails because there is no DEFAULT defined for the last field. However, the user is not notified that the insertion failed until the stored procedure completes.
Properties

Article ID: 155716 - Last Review: 02/28/2014 08:04:45 - Revision: 4.0

Microsoft Visual C++ 2005 Express Edition, Microsoft Visual C++ .NET 2003 Standard Edition, Microsoft Visual C++ .NET 2002 Standard Edition, Microsoft Visual C++ 4.2 Enterprise Edition, Microsoft Visual C++ 5.0 Enterprise Edition, Microsoft Visual C++ 6.0 Enterprise Edition

  • kbnosurvey kbarchive kbtshoot kbbug kbsqlprog kbdatabase kbeedition kbdebug kbprb KB155716
Feedback