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.