SET IMPLICIT_TRANSACTIONS - 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

General SQL Server Forums

New to SQL Server Programming

SET IMPLICIT_TRANSACTIONS

Author

Topic

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-02-02 : 08:34:48

i need to use SET IMPLICIT_TRANSACTIONS on at my application level
not on seesion level, please help

challenge everything

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-02 : 10:23:10

so are you telling that there's no way to initiate transaction from application end?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Kristen
Test

22859 Posts

Posted - 2012-02-02 : 11:57:45

in which case how would the application ever COMMIT an implicit transaction?

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-02-03 : 00:54:57

how to SET IMPLICIT_TRANSACTIONS on , by default for all sessions in sql server

challenge everything

Kristen
Test

22859 Posts

Posted - 2012-02-03 : 03:16:24

If you did how would you COMMIT it ?

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-02-03 : 06:57:55

quote:
Originally posted by pnpsql

how to SET IMPLICIT_TRANSACTIONS on , by default for all sessions in sql server
challenge everything

After pushing F1, i got the following answer:

The SQL Server Native Client OLE DB Provider for SQL Server and the SQL Server Native Client ODBC driver automatically set IMPLICIT_TRANSACTIONS to OFF when connecting.
 SET IMPLICIT_TRANSACTIONS defaults to OFF for connections with the SQLClient managed provider, and for SOAP requests received through HTTP endpoints.

When SET ANSI_DEFAULTS is ON, SET IMPLICIT_TRANSACTIONS is ON.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Kristen
Test

22859 Posts

Posted - 2012-02-03 : 06:59:50

Yeah, but how is the O/P going to COMMIT them?