Post reply

commit mode per connection

  • July 13, 2006 at 1:43 pm

    #75010

    is it possible to tell if a specific user connection to the database is running in auto commit, implicit or explicit commit mode?

     

    thanks

  • July 14, 2006 at 10:07 am

    #649315

    Depends who is asking...

    Use today's Question of the Day:

    Select @@Options

    to return a bit mask for user options. See "User Options Option" article in BOL for the number for each option. here is what it says for Implicit Transactions:

    2

    IMPLICIT_TRANSACTIONS

    For dblib network library connections, controls whether a transaction is started implicitly when a statement is executed. The IMPLICIT_TRANSACTIONS setting has no effect on ODBC or OLEDB connections.

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply