A common pattern to manage SQL stored procedures is to drop the current procedure and recreate it. Unfortunately, this doesn't work if you're trying to run a high-availability service. Here's the (broken) drop+create pattern: -- Delete the stored … [Continue reading]