Post reply

Fatal Errors in T-SQL

  • June 22, 2004 at 2:51 am

    #84820

    Hi there,

    Does anyone know where to look at in the SQL Server environment when searching for fatal errors. I explain : in sql server 2000 there are fatal and non-fatal errors.

    Non-Fatal errors don't stop the process and allow to query the @@error variable in order to take appropriate action.

    Fatal errors simply abort the current transaction where it was and you have no chance to handle them when they occur. A fatal error happens for example when converting a varchar to a datetime variable with an wrong date format.

    I'm using triggers and stored procedures to replicate and transform a database into another structure and I would like to know where to look at to see if any fatal error occured.

    Many thanks for any help.

  • June 23, 2004 at 2:15 am

    #511571

    Apart from checking EM\Management\SQL Server Logs and/or EventViewer\Application Log, you could also configure notifications for system alerts (or your own custom alerts). You can do this via EM\Management\SQL Server Agent\Alerts

     

    Cheers

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply