获取在特定日期创建和/或修改的存储过程列表? [英] Get the list of stored procedures created and / or modified on a particular date?

问题描述

我想找到我创建的存储过程，还想找到我在 2012 年 9 月 27 日 (27/09/2012) 等特定日期在 SQL Server 中修改过的存储过程.

I want to find which stored procedure I've created and also I want to find which stored procedure I've modified in my SQL Server on a particular date like 27 september 2012 (27/09/2012).

是否有任何查询可以列出在此日期创建和修改的这些程序?

Is there any query which will list these procedures that are created and also modified on this date?

推荐答案

您可以在任何给定的 SQL Server 数据库中尝试此查询:

You can try this query in any given SQL Server database:

SELECT 
    name,
    create_date,
    modify_date
FROM sys.procedures
WHERE create_date = '20120927'  

列出名称、创建和最后修改日期 - 不幸的是，它没有记录谁创建和/或修改了相关存​​储过程.

which lists out the name, the creation and the last modification date - unfortunately, it doesn't record who created and/or modified the stored procedure in question.

这篇关于获取在特定日期创建和/或修改的存储过程列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！