How to enable autocommit? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to enable autocommit?

Author

Topic

Ach
Starting Member

13 Posts

Posted - 2005-08-01 : 11:16:02

Hi all,
I want to know,how can I enable autocommit in sql server? I want to set it in system level not at session level.
-Thanks

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-01 : 12:26:08

quote:
Originally posted by Ach

Hi all,
I want to know,how can I enable autocommit in sql server? I want to set it in system level not at session level.
-Thanks

Autocommit mode is the default transaction mode for SQL Server.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources