How to find list of stored procedures in sql server

This query will display list of stored procedure and tables present in databases with their last modified date / updated date. It has one parameter where you can change as per your needs like if you want to find out list of trigger then use ‘TR’ for Trigger and ‘FN’ for function in where clause. ...