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
 Transact-SQL (2000)
 Error Handling in Sql Server Stored procedure

Author  Topic 

shashibilla
Starting Member

1 Post

Posted - 2001-08-10 : 09:52:08
i have problem in handling the fatal error in sql server stored procedure, i have written a stored procedure, there is no client interaction, at present i am unable to handle the fatal exception, when any fatal exception is raise the program is terminated.
actually i want to trap all the error with the message during excution of program and store it in different table, the program should not terminated in middle of excution
there is one object @@Error which gives the error code for non_fatal Error
i want to trap both fatal & non_Fatal error and store in the table

thanks & regrads
shashi

   

- Advertisement -