While looking into some production issues and after much looking into the few functions that span over 700-1000 lines, I stumbled upon the root cause. Oh my what a priceless gem!

private static int somefunction(some params)
{
int iKey = -1;
try
{
//codes transaction
}
catch (SqlException ex)
{
return iKey;
}
catch (Exception ex)
{
return iKey;
}
finally
{
//release or closed whatever
}

  return iKey;

}

oh ya.. Way back in college days, we had Discrete Math subject for 2 consecutive semesters and I didn't understand what was this teacher talking about.He TALKED/WROTE to the board a lot than to his students. Wasted the entire semesters with him.*sigh*

My Husband got to read this!! :laugh: :laugh: