List Modified Stored Procedures

programming-transactsql

Sometimes you just need a list of the stored procedures that have been recently modified. If you run this query, it will show the stored procedures that have been modified in the last 2 weeks (14 days). You can change the query to alter the number of days by changing the 14 to a different number of days.

SELECT Name,Modify_Date 
FROM sys.objects 
WHERE Type='P' 
      AND 
      DATEDIFF(D,Modify_Date,GETDATE())< 14 
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