locked
is it possible to find references?? RRS feed

  • Question

  • Hello All,

    I have a trouble of finding the calling references of a stored procedure in the other stored procedure.

    how can i find calling references in one shot.

    Friday, March 31, 2017 9:07 AM

Answers

  • In SSMS do a right mouse click on the stored procedure => "View dependencies".

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Marked as answer by EmpAnsar Friday, March 31, 2017 9:34 AM
    • Edited by Olaf HelperMVP Friday, March 31, 2017 10:07 AM
    Friday, March 31, 2017 9:18 AM

All replies

  • Hi EmpAnsar,

    Please use SP_DEPENDS <TABLE NAME>/<SP NAME>. It'll display all referenced SPs, FUns etc.

    Thanks DKG


    Friday, March 31, 2017 9:14 AM
  • In SSMS do a right mouse click on the stored procedure => "View dependencies".

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • Marked as answer by EmpAnsar Friday, March 31, 2017 9:34 AM
    • Edited by Olaf HelperMVP Friday, March 31, 2017 10:07 AM
    Friday, March 31, 2017 9:18 AM