changing autocommit mode

Hi:

The first stmts in

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_06_35bq.asp are

"Autocommit mode is the default transaction management mode of Microsoft? SQL Server?. Every Transact-SQL statement is committed or rolled back when it completes."

"if a statement completes successfully, it is committed; if it encounters any error, it is rolled back. A SQL Server connection operates in autocommit mode whenever this default mode has not been overridden by either explicit or implicit transactions."

My question is, how do we change autocommit mode. I don't want the dml to be commited until i explicitly do commit. This should be default setting.

I want this change either to be made at database level, maybe by doing some setting or through some T-SQL stmt.

I DO NOT want to use anything that has to be done in query windows like set ... off | on in each and every query window i use.

The change has to be done only once and should persist through-out.

Any solution will be of help to me.

Thanking you,

Regards,

kumar

Hi,

did you have a look on the server properties in Management Studio under the Connection Setting menu, there is a settin under the default connecting settings with the name: "implicit transactionS" which can be turned on at server level.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||This can also be enabled at the server level by using sp_configure 'user options'. See Books Online for more details on which bit to set in the user options value.|||

Hi:

Thank you for the reply.

But setting the property in studio. To my understanding, it is going to effect all the databases.

I want to set implict transaction to only my database and not for all databases. It should be global to only my database.

regards,

kumar

sql