All I have is the CD's so please do not say RTFM.

I am trying to understand how to use the BEGIN TRANSTRACTION and END TRANSACTION commands to decrease the likelyhood of entering bad data into tables (i.e. only m of n tables is updated, currupted headers, currupted indexes, power surges, etc). I understand its not a cure all but it way help.

Any information and pointers would be appreciated