Results 1 to 2 of 2

Thread: Error Handling

  1. #1
    Join Date
    Jun 2002

    Unanswered: Error Handling

    I want to handle the critical errors in SQL2K. I wrote one stored procedure and try to refreshview, if the dependent table is unavailable then its terminate, I tried to handle it through @@error it won't work.

    Instead of terminate I want to log it in table and continue with another view. I will appreciate if someone help me.

  2. #2
    Join Date
    Mar 2002
    Sql Server will not allow you to handle critial errors.

    You will need to check for the existence of a dependent table first in the sysobjects if you want to avoid such errors.

Posting Permissions

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