Determining when a procedure has been altered

In Microsoft SQL Server, you can easily retrieve this information from the sys.procedures catalog view. The following query demonstrates this. SELECT [name] ,modify_date ,create_date ,* FROM sys.procedures Of course you can take it a step further by limiting the results to a period of time where you know that no changes should have been made. For example, the following query lists all stored procedures that have been changed since August 1, 2007 (the time I last visited this client). SELECT [name] ,modify_date ,create_date ,* FROM sys.procedures WHERE modify_date > '2007-08-01'   From http://weblogs.sqlteam.com/joew/archive/2007/08/29/60312.aspx