是否有可能跟踪最近在SQL Server中修改过脚本（存储过程）的系统？ [英] Is it possible to trace the system, who has modified the script(stored procedure) recently in SQL server?

问题描述

我有一组包含代码的存储过程。但突然有人改变了Proc中的一些代码，并改变了脚本。我不知道是谁做了这个或者从哪个系统修改了程序。只有我能看到的是上次修改的日期和时间。是否有任何可能的方法来跟踪修改脚本的系统。请帮忙。



提前致谢。



我尝试了什么：



SELECT name n1，create_date n2，modify_date n3，* FROM sys.procedures

order by modify_date desc;

只修改日期而不是用户或系统。

Hi,
I had a stored procedure with set of codes. But suddenly some one has changed some code in the Proc and has altered the script. I dont know who has done it or from which system the procedure is been modified. Only I can see is last modified date and time. Is there any possible way to trace the system from where the script has been modified.? Please help.

Thanks in advance.

What I have tried:

SELECT name n1 , create_date n2 , modify_date n3,* FROM sys.procedures
order by modify_date desc;
It only has date modified not the user or system.

推荐答案

有一个内置报告显示了这一点。从Sql Management Studio右键单击您的数据库，选择报告，标准报告，架构更改历史记录。这将显示谁最后改变了它。

There is a built-in report that shows this. From Sql Management Studio right-click your db, choose Reports, Standard Reports, Schema Changes History. That will show who changed it last.

这篇关于是否有可能跟踪最近在SQL Server中修改过脚本（存储过程）的系统？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！