Search code examples
sql-server-2012transactionsansi-sql

IMPLICIT_TRANSACTIONS for selected operations

I like IMPLICIT_TRANSACTIONS (via Options > Query Execution > ANSI > SET IMPLICIT_TRANSACTIONS) for update, insert, etc, but I do not want it for select

(See this MDSN)

Is this possible in SQL Server 2012?

This is a follow-up question from this post

Many thanks in advance!

Solution

  • Nope, unfortunately it's all or nothing, a new transaction will be started for all statements listed in that article unless the connection is already in an open transaction.