Will MTS rollback a transaction when it encouters an error after a database table is truncated. For e.g. I am executing 2 stored procedures under a Transaction which is handled by MTS. In the first stored procedure I truncate a table and if there is an error in the execution of 2 stored procedure will the changes made by stored procedure be rollbacked by MTS.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MTS RollBack in case of TRUNCATE Table
- Thread starter pankajv
- Start date
Similar threads
- Locked
- Question
- Locked
- Question