Dependencies changing when an object changes
lgrieser
Posts: 5 New member
Hello,
A fellow DBA observed this morning that some dependencies of an object that SQL Compare changed show as also having changed in the SSMS Object Explorer Details. We can't find any observable changes so I'm assuming SQL Compare is doing something in the background to update those objects. We're just looking for assurance that this is normal and expected behavior.
A fellow DBA observed this morning that some dependencies of an object that SQL Compare changed show as also having changed in the SSMS Object Explorer Details. We can't find any observable changes so I'm assuming SQL Compare is doing something in the background to update those objects. We're just looking for assurance that this is normal and expected behavior.
Tagged:
Best Answer
-
Michelle T
Posts: 566 Gold 1
Yes - this is normal behaviour when we have to 'rebuild' or 'unbind' objects in the middle of a deployment - e.g. a schemabound function that depends on something that you've changed.
If there weren't any changes to that object, we will put it back the way it was by the end of the deployment, but we have to modify it briefly in the middle of the deployment to perform the requested actions.
Software Developer
Redgate Software
Answers