Not Autocommit

Aug 2, 2001

I want to know how to set not autocommit at SQL Server 6.5 database ?
Please Help

View 1 Replies


ADVERTISEMENT

Set Autocommit Equivalent ?

Jul 8, 2004

Hi,

What is the SQL Server equivalent for "set autocommit on" of Oracle ?

Thanks,
Sam

View 4 Replies View Related

Question On Autocommit

Feb 6, 2008



How do i find the current status of autocommit. whether it is set to ON or OFF.

Is there any way to check this out thru management studio ?

View 4 Replies View Related

Changing Autocommit Mode

May 9, 2006

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

View 4 Replies View Related

Disabling The AUTOCOMMIT Option In MSSQLServer

Jun 8, 2006

Hello,Is there anyway.. we can disable AUTOCOMMIT option in MSSQL serverwhile executing the SQL queries via SQL ANALYZER

View 2 Replies View Related

Rollback In A Trigger??? (explicit/autocommit Transactions)

Jun 21, 2006

I€™m using triggers for some more advanced integrity check. The problems is that the same trigger can be run from explicit transaction (this is when I start transaction from .NET) and as autocommit transaction ( very rare, only when we do some maintenance directly with SQL statements).

Currently if I want to rollback transaction from trigger I only issue RAISERROR statements, then .NET application catches this error and generates rollback. But the problem is if trigger is raised from some SQL statements outside .NET application (normally some maintenance work direct from SQL manager ) in that case error is generated but there is no rollback.

Is there any way to distinguish if transaction in trigger is explicit or autocommited, because for autocommited transaction I also need use ROLLBACK TRANSACTION?

I€™m using SQL 2005!

Best regards
edvin

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved