Option to Drop/Create Procedures instead of Alter

Grant Fritchey

I've looked around and I can't find this, so I'm assuming it's not there. Please correct me if it is. Is there a mechanism to force the scripts to drop procedures and recreate them rather than running ALTER statements?

The reason for this is because we have a large number of databases running in Express. We have a master database that they are all supposed to have an exact copy of, but sometimes, well, the copy isn't exact. If they have an exact copy, ALTER will work great. But if the copy is off, DROP & CREATE will work better.

David Atkinson

I'm not sure I understand. Is this because ALTER assumes the object exists, whereas DROP/CREATE will work regardless?

David Atkinson
Red Gate Software

Grant Fritchey

I must have explained that poorly, but yes, you're stating the problem exactly.