Subject Re: Commenting whole procedures
Author Adam
> I am trying to get new versions of our app to detect whether metadata
> changes are required, and to automatically carry them out.
> Commenting out the entire procedure would remove the dependencies
> while table and field changes are being made.

Hello Roger,

We just use FlameRobin (freeware, see website for
link) to do this. There is a Generate Rebuilt script for different
objects, which takes care of dropping and recreating the dependent

Other tools can accept an original and target database and generate a
script to convert it.