I generated a sqlscript of my entire db and created a new db from it. I received an error when I ran the sql script in QA. Here is the error: "Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'LogDetails'. The stored procedure will still be created."
When I looked in the newly created database, the stored proc LogDetails is there? Could this be because of some PK or FK issues somehow?
sql server holds a record of dependencies by object ID. If SP A calls SP B then it records this fact. If B has not yet been created then it doesn't have an object ID and so the dependency cannot be recorded and this is what the error message is saying. For running it doesn't cause a problem as long as B is created before A is run as the query plan is created on first run.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.