12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
建站问答 时间:2024-12-02 12:55:49
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
在 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
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19