TSQL to get list of Stored Procedures created in last x days

Comments

# Madhivanan said on August 2, 2007 4:13 AM:

I think that should be

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,create_date, GETDATE()) < 7

to find procedures created for the last 7 days

# SQL Master said on August 2, 2007 5:52 AM:

You are right, its a typo.

thanks

# SSQA.net - SqlServer-QA.net said on August 3, 2007 3:32 AM:

SELECT name FROM sys.objects WHERE type = &#39;P&#39; AND DATEDIFF(D,create_date, GETDATE()) &gt; 7.

# Other SQL Server Blogs around the Web said on August 6, 2007 9:53 PM:

SELECT name FROM sys.objects WHERE type = &#39;P&#39; AND DATEDIFF(D,create_date, GETDATE()) &gt; 7.

About SQL Master