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.