Posted by sjoshi on 08/28/06 20:05

Hello
I had a question reagrding MSDTC usage. I know that MSDTC will enlist
each connection transactions as it's own (take ownership) and
commit/abort accordingly.

However I'm not sure what would happen where I have a stored proc with
input parameters and 2 Delete commands on 2 different tables. In this
case, would MSDTC also enforce ACID rules when 1 cmd succeeds and 2nd
aborts ? In the script for the Stored Proc, there is no checking for
@@ERROR value. There are just DELETE statement and a plain RETURN.

thanks
Sunit

• Next in forum: OLE error code:80040E14
• Prev in forum: MSSQL2K5 Install Path
• Thread view: MSDTC and Delete transactions

[Reply to this message]