This makes the transaction uncommittable when the constraint violation error occurs . use adventureworks ; go - check to see whether this stored procedure exists 在本示例中, set xact _ state为on ,在发生违反约束的错误时,这会使事务处于不可提交状态。
As project manager , you decide how often workgroup members have to respond to status report requests , the sections the reports will contain , and the look of the reports 作为项目经理,您可以确定工作组成员提交状态报告的频率,并确定报告包含的内容以及报告的外观。
By comparing figure 1 and figure 3 , you can easily see the change in the " shape " of the order as it moves from open to submitted states in the business process shown in figure 2 通过比较图1和图3 ,可以很容易发现随着order的状态在业务流程中由开放进入已提交状态(如图2所示) ,其“形状”发生了更改。
When a durable resource manager restarts , it reconstructs the committed state of the resources it manages by retrieving the prepare information written in the prepare phase , and commits or aborts these transactions accordingly 在持久性资源管理器重新启动时,它通过检索在准备阶段中写入的准备信息,重新构造它管理的资源的提交状态,并且相应提交或中止这些事务。