Change scripts should have existence checks on every object they add - tables, constraints, etc.
I've encountered this, especially with default constraints. I generate a change script. I run it on a system. Something happens that causes the script to fail. I fix the problem, but then it fails the second time because the default constraints it is trying to create are already there!
4
votes
Richard Handloff
shared this idea