Is there any automated way that will list all dependencies in sql server stored procedures? -
There are approximately 1449 stored procedures in our database. Is there an automated method that will list all dependencies? As we have called C2, S2, S3, S4, S5, CS, S2, S3 in S1 s4 is called in s3 Dependency should look something like s1 - & Gt; S2 - - & gt; S4 - & gt; S3 ---- & gt; S5 In my opinion, you can add all your SP names to a temporary table , Select from . Sysprocedures You can now loop through temp tables and dependencies like DECLARE @ search varchar (255) SET @ search = ' Select 'PROCEDURE_NAME' object_on, o Type. Sys.qql_modules from O-Type_Desk M Inner Join Sys.objects o on m.object_id = o.object_id WHERE m.definition '%' + '%' like search by ORDER 2,1 I do not know whether it will work or not, but you can give it at least one try.