• You can run this script to check for late-binding issues:

    -- Based on comment from http://blogs.msdn.com/b/askjay/archive/2012/07/22/finding-missing-dependencies.aspx

    -- Check also http://technet.microsoft.com/en-us/library/bb677315(v=sql.110).aspx

    select o.type, o.name, ed.referenced_entity_name, ed.is_caller_dependent

    from sys.sql_expression_dependencies ed

    join sys.objects o on ed.referencing_id = o.object_id

    where ed.referenced_id is null