I've used the same approach for many years and it's saved me more times than I can remember.

I agree with @simoesp that I'd have the rollback by default....

Hey,

Thanks for sharing your knowledge, though I suspect the "Let's Start with Architecture" link at the bottom is incorrect.  It's currently to an article from 2012 🙂

Hope this helps.

https://toepoke.co.uk

Hey Steve,
Great article, and thanks for sharing.
You discussed whether to use create procedure or create a stubb proc and do an alter.  Finishing off with "I'm not sure...