Transactional DDL rollback behavior under concurrent load
Transactional DDL Rollback Behavior Goal: Determine if rolling back a large schema change is truly safe when other sessions are active. Constraints: The rollback must not hold Sch‑M locks for an unacceptable duration, and should not cause significant blocking of readers or writers on the affected object. Open Issues SQL Server supports transactional DDL, but