Get Stored Procedure Definition, Create_Date and Modify_Date (Created_Date and Modified_Date) by T-SQL


--use yourDB
--GO

SELECT
	o.name,
	o.TYPE,
	o.create_date,
	o.modify_date,
	m.definition
FROM sys.objects o
INNER JOIN sys.sql_modules m
	ON o.object_id = m.object_id
ORDER BY o.modify_date DESC
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s