Script to Generate Table to Stored Procedure Cross References

• aleksey donskoy

  Mr or Mrs. 500

  Points: 565

  More actions

  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

• Alberto Turelli

  SSC-Addicted

  Points: 448

  More actions

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  February 17, 2016 at 4:56 pm

  #1859438

  Thanks for the script.