In SQL Server 2000, If i generate SQL Scripts for all the Stored Procs,
to be run in a new database of the same schema, and run them across,
I recieved warning messages

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object "stored proc name". The stored procedure will still be created.

I presume, this is because the object that I am trying to create, depends on the other stored proc which is yet to be created.

The stored proc is created but does not create the rows in the sysdepends table.

How can I generate the scripts in the order that I do not recieve the warnings.

It would be of great help if anybody can sove this..

Thanx in advance