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 procedure if it already exists if exists ( select * from sys.objects where name = N’p_MyProc’ and […]