• I see where you start an explicit transaction (BEGIN TRANSACTION), but I don't see where you commit or rollback the transaction(s) (COMMIT or ROLLBACK).

    If you start an explicit transaction you have to commit or roll back that transaction explicitly.

    I am curious if you actually have 600 separate transactions open using the GO 600. Which means you may need to issue 600 COMMITs.