Home Forums SQL Server 2005 T-SQL (SS2K5) How to use begin try and transaction with in a loop which call other stored procs. RE: How to use begin try and transaction with in a loop which call other stored procs.

  • March 19, 2014 at 8:22 am

    #1698387

    rajemessage 14195 (3/19/2014)

    We are considering set base apporch for new devlopment

    but following is quite complicated SP, which i can not change now.

    So please tel me technically the way i have used transaction are ok or not.

    It should work, did you look at my example?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience