List all Stored Procedure Created and Modified in Last N Days in SQL Server 2008


In this post, we will discuss how we can retrieve all the stored procedures created and modified in last N days in SQL Server 2008.


Also, you can check out my previous posts on:

Working with enterprise library for data access in asp.net Part-3

How to handle the exception in the sql server stored procedure?

Forms-based authentication in asp.net

Below is the query that will give us all the stored procedures that have been created in the last 30 days:

SELECT name
FROM sys.objects
WHERE type = ‘P’
AND DATEDIFF(D,create_date, GETDATE()) < 30

Below is the query that will give us all the stored procedures that have been modified in the last 30 days:

SELECT name
FROM sys.objects
WHERE type = ‘P’
AND DATEDIFF(D,modify_date, GETDATE()) < 30



Hope it will be useful to you !!!

Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →