I have an application in production that use a lot of stored procedures and the application doesn´t record any error if any during the operation. (There is only a RESUME NEXT sentence).
So I want to know if there is a way to make SQL Server to register an error if any during the execution of a Stored Procedure without changing any of them. Say, that I want SQL Server to register an error during an execution of an user defined Stored Procedure as an internal error.
Originally posted by rnealejr
Is there a problem trapping the error in the application (get rid of the resume next and handle the error) ?
Yes, the application is in the production environment and we have to solve the problem as soon as posible. If we change the code in the application then after that we should test the app, and we don´t have time.