June 22, 2004 at 2:51 am
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
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