Understanding SQL Server's Limitations with DDL Rollbacks and Best Practices for Data Integrity