Generate Sql Script with Dependencies

In Sql Server 2000, when you Generate Sql Script, it may create the stored procedures in the wrong order so that you it causes errors when run due to forward references. To solve this, in the Generate SQL Scripts dialog, go to the formatting tab and select “Generate scripts for all dependent objects”.