How can we help you today? How can we help you today?

Dependencies changing when an object changes

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.
lgrieser
0

Comments

2 comments

Sort by
  • Michelle T
    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.
    Michelle T
    0
  • lgrieser
    Thanks Michelle!
    lgrieser
    0

Add comment

Please sign in to leave a comment.