"Jim Underwood" <james.underwood_nospam@fallonclinic.org> wrote in message
news:eEWo$v3BIHA.5868@TK2MSFTNGP05.phx.gbl...
> Usually, I put my scripts together manually, because this issue troubled
> me and I never got around to trying to find a solution for it. I did try
> checking off "Generate scripts for all dependent objects" and that did not
> help at all, although it did change the order of the script, just in
> useless ways.
>
> If you do find an answer, please let us all know.
>
> "Charles Law" <blank@nowhere.com> wrote in message
> news:Odetnj3BIHA.3564@TK2MSFTNGP04.phx.gbl...
>>I don't know if I have missed something here, but I blindly thought that
>>if I used SSMS to script my database, I could run the script on a new
>>instance and get a database out of it.
>>
>> The script fails, and I get an error saying that a stored procedure
>> requires an object that doesn't exist. That is because the object hasn't
>> been created yet. It appears later on in the script.
>>
>> How can I get the database scripting wizard to script objects in the
>> correct order, that is in an order that takes account of dependencies?
>>
>> Either that, or does anyone know of a tool/product that does do this?
>>
>> TIA
>>
>> Charles
>>
>>
>
>

On Oct 5, 12:55 pm, "Charles Law" <bl...@nowhere.com> wrote:
> I don't know if I have missed something here, but I blindly thought that if
> I used SSMS to script my database, I could run the script on a new instance
> and get a database out of it.
>
> The script fails, and I get an error saying that a stored procedure requires
> an object that doesn't exist. That is because the object hasn't been created
> yet. It appears later on in the script.
>
> How can I get the database scripting wizard to script objects in the correct
> order, that is in an order that takes account of dependencies?
>
> Either that, or does anyone know of a tool/product that does do this?
>
> TIA
>
> Charles

Charles Law wrote:
> [...]
> How can I get the database scripting wizard to script objects in the
> correct order, that is in an order that takes account of dependencies?
>
> Either that, or does anyone know of a tool/product that does do this?