在Sql Server/T-SQL中关闭日记功能 [英] Turn off Journaling in Sql Server/ T-SQL

问题描述

我需要在Sql Server/T-SQL中关闭日记功能，以写入as400中的文件/表.我发现您可以使用Pragma在SQLite中完成此操作.但是，我发现T-SQL中不存在.有什么想法吗?

I need to turn off journaling in Sql Server/T-SQL to write to a file/table in as400. I have found that you can do it in SQLite with Pragma. However, I have discovered that doesn't exist in T-SQL. Any ideas?

谢谢！

推荐答案

您需要在链接上禁用承诺控制.您正在使用哪个提供商?

You need to disable commitment control on the link. Which provider are you using?

.NET

DefaultIsolationLevel=Chaos

OLEDB(IBMDA400)

Extended Properties="Default Isolation Level=NC;Auto Commit Mode=True"

ODBC

CommitMode=0

这篇关于在Sql Server/T-SQL中关闭日记功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！