Get List of Last Changed Stored Procs in SQL Server

Sometimes when you have created/updated several stored procs in your database in SQL Server and you only need to transfer the changed ones to another copy of the database, then the best way is to get a listing of the stored procs by date.

 

select name, modify_date from sys.procedures order by modify_date desc

This saves you the whole trouble of remembering which stored procs were added or updated of late.

1 Trackback / Pingback

  1. Cheap PHP Script

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.