Re: Error hanlding in Stored procedure or .Net Application

Thanks for your reply.



"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:526396DF-41B1-4233-8EC5-77CB7ED6A32B@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Error Handling.
    ... You have to grant execute to the stored procedure. ... figure out the signature and has the permissions, ... Error handling in your sprocs is necessary for performance, ...
    (microsoft.public.sqlserver.clients)
  • Re: Error Handling.
    ... BEGIN TRANSACTION statement inside of a stored procedure, ... server is less efficient and more prone to problems. ... Error handling in your sprocs is necessary for performance, ...
    (microsoft.public.sqlserver.clients)
  • RE: YA Stored Procedure Question
    ... > Subject: YA Stored Procedure Question ... > The SP builds a temp table, updates the source table from the temp ... The update statement executes. ... > and the perl that runs this (I removed the error handling for brevity): ...
    (perl.dbi.users)
  • Error handling
    ... I have created a simple stored procedure to handle updates to a SQL table. ... form of error handling or just use standard error handling within Access?? ...
    (microsoft.public.sqlserver.programming)
  • RE: YA Stored Procedure Question
    ... Subject: YA Stored Procedure Question ... The SP builds a temp table, updates the source table from the temp ... The update statement executes. ... and the perl that runs this (I removed the error handling for brevity): ...
    (perl.dbi.users)
Loading