>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