Timeline for Organizing Stored Procs and Views

5 events

when toggle format	what		by	license	comment
Mar 28, 2017 at 18:41	history	edited	marc_s	CC BY-SA 3.0	added 45 characters in body
Jun 9, 2016 at 14:33	vote	accept	scripter78
Jun 9, 2016 at 14:33	comment	added	scripter78		SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name, o.type_desc AS referencing_desciption, COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id, referencing_class_desc, referenced_server_name, referenced_database_name, referenced_schema_name, referenced_entity_name, COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name, is_caller_dependent, is_ambiguous FROM sys.sql_expression_dependencies AS sed INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id
Jun 9, 2016 at 14:20	comment	added	scripter78		So far this query which after a ton of searching and only finding right after posting this broad question I found on a microsoft site. seems to have provided a lot of help and goes along with your suggestions Although it does not provide a referrencing list of tables but it looks like your suggestions might do that SELECT * FROM sys.dm_exec_procedure_stats AS s INNER JOIN sys.procedures AS p ON s.[object_id] = p.[object_id] ORDER BY p.name;
Jun 9, 2016 at 13:50	history	answered	dfundako	CC BY-SA 3.0