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