how to disable the AUTOCOMMIT option in MSSQLServer
In Query Analyzer (for SQL Server 2000): Tools / Options / Connection
Properties / Set implicit_transactions to ON. This affects only new
connections.
Also in Query Analyzer: Query / Current coonnection pproperties / Set
implicit_transactions ON to affect the current connection.
In SQL Server Management Studio (for SQL Server 2005):
Tools / Options /Query Execution / SQL Server / ANSI / SET IMPLICIT_TRANSACTIONS ON (for
new connections),
and Query / Query Options / Execution / ANSI / SET
IMPLICIT_TRANSACTIONS ON (for the current connection).
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10640532/viewspace-588849/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- ORA-12505: Using Oracle RAC and Java JDBC thin client Connection
- Oracle Database Server 'TNS Listener'远程数据投毒漏洞
- EXP-00106: 数据库链接口令无效
- exp遇到错误ORA-06512 SYS.DBMS_EXPORT_EXTENSION
- DROP USER ORA-00600[16206]
- ORACLE口令文件
- oracle decode用法
- Oracle to_char()
- 切换TEMP表空间遭遇enq: TS - contention
- ORA-01555 on Active Data Guard Standby Database
