Monday, September 3, 2007

SQL Server@ List Stored Procedure Names Created in Specific Date Range

This simple query returns the list of stored procedure names that are created with in the specific data range given in where clause.

SELECT Name,create_date,modify_date
FROM sys.procedures

WHERE create_date between '07/14/2007' and '08/20/2007'


No comments: