Error hanlding in Stored procedure or .Net Application

#31

Thanks for your reply.

"Linchi Shea" <LinchiShea (AT) discussions (DOT) microsoft.com> wrote

Quote:

By the way, Adam Machanic has a chapter on errors and exceptions handling
in
his book "Expert SQL Server 2005 Development". You may want to take a
read.
Also, he did a presentation on the same topic at this year's TechEd, but
I'm
not sure if the presentation can be found online somewhere.

Linchi

"Rogers" wrote:

Dear Professional,

I had serious debate in my organization and I told to my developers to
use
Error Handling in Stored procedure BEGIN TRY END TRY BEGIN CATCH END
CATCH
but they are saying error handling is better in .Net code instead of
stored
procedure,

Please advice me which way is better and give me any solid reason so that
I
can explain them very easily.

Your help is really appreciated

Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error hanlding in Stored procedure or .Net Application

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Error hanlding in Stored procedure or .Net Application - 07-19-2008 , 09:20 AM