SELECT distinct 'DROP PROCEDURE [dbo].[' + OBJECT_NAME(referencing_id) + ']' as Perig   FROM sys.sql_expression_dependencies AS sed  
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id  
WHERE  o.type_desc = 'SQL_STORED_PROCEDURE'
AND referenced_entity_name NOT IN ( SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES  )
Order By Perig


delete from _Used_SP 
Insert Into _Used_SP ( Perig) 
SELECT distinct OBJECT_NAME(referencing_id) FROM sys.sql_expression_dependencies AS sed  
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id  
WHERE  o.type_desc = 'SQL_STORED_PROCEDURE'
AND referenced_entity_name NOT IN ( SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES  )
Order By OBJECT_NAME(referencing_id)

Select  'DROP PROCEDURE [dbo].[' + Perig + '] ;  GO ' from _Used_SP