Option to Drop/Create Procedures instead of Alter
Grant Fritchey
Posts: 72
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.
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.
Comments
David Atkinson
Red Gate Software
Product Manager
Redgate Software