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

InfoPath alternatives for form designing SharePoint

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 !!!


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 →

Leave a Reply