• correct, it appears the identity is not part of the transaction. The main reason is that if someone else were to run this with you, you wouldn't want them to be blocked from insrting a row because you held a "lock" on the identity area.

    Steve Jones

    sjones@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/

    http://www.dkranch.net