Dependencies changing when an object changes

lgrieserlgrieser Posts: 5 New member
edited May 16, 2019 2:04PM in SQL Compare
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. 
Tagged:

Best Answer

  • Michelle TMichelle T Posts: 566 Gold 1
    edited May 16, 2019 2:28PM Answer ✓
    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

Sign In or Register to comment.