Hello everyone,
I have a bunch of DDL's that are to be run on a db.All the script is doing is dropping a bunch of tables, constraints and then creation of some tables. The problem is when i run the script all together as a single script, i get the error
"Cannot find the object " dbo.example" because it does not exist or you do not have permissions"
I see a bunch of these errors when i run it altogether.. to trouble shoot.. ran each single script to drop or create the constraint, table separately, it works fine. Even the execution order also does not change.. but still.. I dont understand .. why does this happen?
Thanks!