Get stored procedures create and modify dates

SELECT name, create_date, modify_date 
FROM sys.objects
WHERE type = 'P' 

Fetch the row count for all tables in a SQL SERVER

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
DROP TABLE #counts