• ADADADADAD

    SQL Server分布式事务如何处理[ 建站问答 ]

    建站问答 时间:2024-12-02 12:55:49

    作者:文/会员上传

    简介:

    在 SQL Server 中,处理分布式事务通常涉及以下步骤:设置分布式事务:使用 BEGIN DISTRIBUTED TRANSACTION 开始一个分布式事务。指定事务管理器(Transaction Manager)。BEGIN DIST

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    在 SQL Server 中,处理分布式事务通常涉及以下步骤:

      设置分布式事务:

      使用 BEGIN DISTRIBUTED TRANSACTION 开始一个分布式事务。指定事务管理器(Transaction Manager)。
      BEGIN DISTRIBUTED TRANSACTION WITH (XACT_TIMEOUT = 60,MAX_LOG_SIZE = 1024 MB,LOG_BACKUP_ALIGNMENT = 1 MB,LOG_BACKUP_SIZE = 1024 MB,LOG_BACKUP_COUNT = 10,COMMITTED_TYPE = 2,COMMITTED_VALUE = 1,DEADLOCK_PRIORITY = 10000,ENCRYPTED = OFF,ALLOW_SINGLE_USER = OFF,READ_ONLY = OFF,TRACK_ACTIVITY = OFF,XACT_IS_ROUNDDOWN = OFF,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_PREEMPTIVE_ABORT = OFF,XACT_SYNCHRONIZED = OFF,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT_COMMIT_DELAY = 0,XACT_COMMIT_RATE = 0,XACT_COMMIT_MODE = AUTO_COMMIT,XACT_SUPPRESS_杨洋 = OFF,XACT_USER_INSTANCE = OFF,XACT_AUTO_COMMIT_SUBTRAN = OFF,XACT

    SQL Server分布式事务如何处理.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: sqlserver