Post reply

Script to Generate Table to Stored Procedure Cross References

  • June 25, 2015 at 2:06 pm

    #1808233

    Alberto:

    This works fine, but 2 things:

    1. It will not work on SQL 2005 as it does not have the sys.dm_sql_referencing_entities view

    2. It will not work if the formal references have been broken (as one of the parties has been dropped/created).

    So the original script, even being painfully slow, shows everything that has been coded to the stored proc definition.

    Aleksey

  • June 26, 2015 at 12:50 am

    #1808322

    Thanks for pointing out, Aleksey, and thanks for the whole idea of getting the dependencies right from the DB metadata.

  • February 17, 2016 at 4:56 pm

    #1859438

    Thanks for the script.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply