Generate view and stored proc scripts retaining depandancy order

Hi,
We need to generate view and stored proc scripts so that they are
generated in the right order. eg
ViewA uses ViewB
Generate
--
ViewB
ViewA
etc
When using Enterprise Manager it just dumps the views and stored procs
alphabetically.
regards
PaulUsing EM, there is no guarantee that it'll generate the SP scripts in the
correct dependency order. To be sure, you need to sort then generated
scripts yourself.
I do this by using a script to scanning the SP scripts, find all the
immediate dependencies, and sort the SP by depdendency.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Paul Sjoerdsma" <paul.sjoerdsma@.redsnapper.nl> wrote in message
news:MPG.19e266ada9d972919896c3@.127.0.0.1...
> Hi,
> We need to generate view and stored proc scripts so that they are
> generated in the right order. eg
> ViewA uses ViewB
> Generate
> --
> ViewB
> ViewA
> etc
> When using Enterprise Manager it just dumps the views and stored procs
> alphabetically.
> regards
> Paul