ALTER TABLE SWITCH rollback behavior with active referencing transactions
Transactional DDL in SQL Server generally allows most CREATE, ALTER and DROP statements to be rolled back inside an explicit user transaction. Partition switching via ALTER TABLE ... SWITCH is a metadata operation intended to move data between partitions with minimal logging. The design question is whether the switch remains fully rollback safe when active t
microsoftsqlserver