Comments
Sort by recent activity
Chris Auckland wrote:
Thanks for your post.
I'm interested to know how the recomplile is invalidating other objects in your database. Is that just during the recompile, or is it breaking them completely in some way?
Hi Chris,
It's just the re-compile causing the invalidation of other objects that are dependent on the object being compiled.
We're in a position where we cannot use the deployment scripts created by Schema Compare (at least without tweaking them) for promoting changes to our live environment as we know these compile statements will invalidate other packages.
It would be really useful to have an option to turn these statements off.
And another nice feature would be the option to have the script perform a compile of any invalid objects in the schema at the end. / comments
Chris Auckland wrote:
Thanks for your post.
I'm interested to know how the recomplile is invalidating other objects in your database. Is that just during the recompile, or is it breaking them co...