sql - 如何在 SQL Server 2008 中找到存储过程的最后修改日期、修改用户？

Question

我需要查找修改特定存储过程的人的用户名。

How do I find out when a stored procedure was last modified or compiled in Oracle?

让我了解时间。但我怎么知道修改它的用户呢？

Answer 1

这对我有用:-

DECLARE @filename VARCHAR(255) 
SELECT @FileName = SUBSTRING(path, 0, LEN(path)-CHARINDEX('\', REVERSE(path))+1) + '\Log.trc'  
FROM sys.traces   
WHERE is_default = 1;  

SELECT gt.HostName, 
       gt.ApplicationName, 
       gt.NTUserName, 
       gt.NTDomainName, 
       gt.LoginName, 
       gt.SPID, 
       gt.EventClass, 
       te.Name AS EventName,
       gt.EventSubClass,      
       gt.TEXTData, 
       gt.StartTime, 
       gt.EndTime, 
       gt.ObjectName, 
       gt.DatabaseName, 
       gt.FileName, 
       gt.IsSystem
FROM [fn_trace_gettable](@filename, DEFAULT) gt 
JOIN sys.trace_events te ON gt.EventClass = te.trace_event_id 
WHERE EventClass in (164) --AND gt.EventSubClass = 2
ORDER BY StartTime DESC;

来源:- https://serverfault.com/questions/258111/finding-out-who-has-modified-a-stored-procedure-on-sql-server