Rolling Back a Transaction in the Transaction Log File

To prevent data corruption, SQL Server does not support the rollback of individual transactions. For example, suppose that two transactions, T1 and T2, use a cash balance field. T1 adds $500 U.S., and T2 makes a change by using that new value. If you roll back T1, T2 might be wrong. However, you can

Read More - Register for Free Membership