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