SQL statement to find modified stored procedures in SQL Server Database
Thursday, July 8, 2010 8:32Posted in category SQL Server
Most of the time we need to copy the stored procedures from development to production database server. That time we need to find out list of stored procedures modified. Here is the simple sql query to order the stored procedures modified.
select name, create_date, modify_date from sys.objects where type='P' order by modify_date desc
To find stored procedures modified after specified date
select name, create_date, modify_date from sys.objects where type='P' and modify_date > '2010-05-26 12:10:44.810' order by modify_date desc
To find stored procedures modified in last 15 days
select name, create_date, modify_date from sys.objects where type='P' and datediff(day, modify_date, getdate()) <= 15 order by modify_date desc
You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.
Chuckles says:
July 24th, 2011 at 11:45 am
Thanks alot – your answer soelvd all my problems after several days struggling