Isn't there a way to load scripted objects out of order?

[musik]

If I've scripted SP's and views out to files, I seem to remember there's a way around the problem of dependent objects being created before the objects they depend on, basically deferring their compilation until all objects have bene loaded.

Am I smoking something or is there a way to do this?

Or do I just have to carefully load them in order?

Thanks!

 

[aalmeida]

The best way is to Load them in Order and commit the create ddl with a go or you could in you create use a if exists drop ddl and then creat it then all you need to do is run it twice, on the second run should not give you any dependency errors AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"