>you should not be able to create the second if the first doesn't not exist, right?

That's how 6.5 used to work. You could not create a database object unless all objects that it was dependent on already existed. This was a royal PITA!

>What would happen if you create the spA then spB then drop and create spA, will i lose the dependency?

Yup.

-Mike