• There's a chance with that kind of procedure that you're also dealing with ad hoc execution. If you have ad hoc T-SQL, you may find that you won't see all the tables through the dependency tracker.

    Probably your best bet to getting this right is the Mk I Eyeball. Approach it like eating an elephant, one bite at a time.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning