Structure transactions


do you know you can use transactions on structure updates in SQL Server? This way you can be sure the complete script is executed, or nothing. Saves me time in having partially updated databases when something went wrong. It's only a few lines to be added to the script, but you could do that by default for SQL Server connections because it is supported from version 2000 onward.

Best regards,

Hugo Logmans