Hi Jacob,
Thanks for taking the time.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Test2](
[ID] [int] NOT NULL,
[Test_Value] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
There isn't a transaction around that, in this example. The SELECT takes about 7 seconds to run against the two million rows and will be within its own transaction. Place a BEGIN TRANSACTION and COMMIT around those and it does the same.
I'm getting the behaviour I'm expecting, but it isn't being confirmed by the 1200 setting, so I wanted to make sure I wasn't misunderstanding something.