Comments (3)

  1. Hey Robert,

    The behavior is very different in SQL Server 2012, so I am assuming you tested only SQL Server 2008 or 2008 R2 behavior above. In 2012 you don’t get LOP_IDENT_NEWVAL records for the insert anymore.

    1. You’re right. I did not test it on SQL 2012.

  2. […] Is SELECT Identity()..INTO Minimally Logged in Simple Recovery? – A very interesting T-SQL walk through from Robert L. Davis(Blog|Twitter). […]

Leave a Reply

Your email address will not be published. Required fields are marked *