Results 1 to 4 of 4

Thread: Error recording

  1. #1
    Join Date
    Aug 2002
    Posts
    25

    Question Unanswered: Error recording

    Hi all,

    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.

    Thanks in advance.

    God Bless.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Is there a problem trapping the error in the application (get rid of the resume next and handle the error) ?

  3. #3
    Join Date
    Aug 2002
    Posts
    25
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Off the top of my head - you could use alerts (but that would be tedious) - do you know what errors you want to trap ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •