hi

I'm using transactions in my code.
If a transaction is done and it is comitted partially then putting
XACT_ABORT ON before that transaction will take care of that and
will rollback all transaction.if the roll back is happened how can
i catch that rollback has happened as i am running 'stored proc'
from front end in a loop . i want to catch rollback event has
done by XACT_ABORT and throw a error
to frontend from SQL so that I can come Out of loop stopping
Execution.
can u help me

regards
sunil



Sunil G. Manjarekar
PGDST (NCST)
B.E.Electronics

___________________________________________________
Meet your old school or college friends from
1 Million + database...
Click here to reunite www.batchmates.com/rediff.asp


MS Sql Server LazyDBA home page