Article ID: 155716 - View products that this article applies to.
This article was previously published under Q155716
This article has been archived. It is offered "as is" and will no longer be updated.
When single-stepping through a SQL Server stored procedure, error messages, if generated, are not displayed at the point where the error occurred.
We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
To reproduce this behavior, create and single-step through the following stored procedure in the SQL Server Pubs sample database:
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.
Article ID: 155716 - Last Review: February 28, 2014 - Revision: 4.0