Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Fatal-Error checking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-02 : 09:06:47
Bomkesh writes "Hi friends,

I am facing Problem with fatal error in Stored Procedure. Actually I want to write my error decription in Application event log. It is working with non-fatal error, but I can’t catch fatal error decription.

can u help me to trap fatal errors in stored procedure ?

Thank you,
Bomkesh Chakarvorty
SISL"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-02 : 09:27:17
It needs to be trapped at the application.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-07-02 : 13:04:36
> It is working with non-fatal error, but I can’t catch fatal error decription.

You mean using RAISERROR using WITH LOG?

Kristen
Go to Top of Page
   

- Advertisement -