• Angel,

    If I remember correctly (from experience only I don't have anything to back this up) sql_dependencies isn't able to report all dependencies (flaw or by design?).

    SSMS use this for the dependency feature and it's not accurate (for SS2k8 R2 RTM) on our side.

    The missing objects aren't deferred one and aren't inside dynamic SQL either. Just some plain objects.

    The only way I as able to get the job done was searching using object_definition.