sql to search who modified

1SELECT DISTINCT
2              StartTime
3          ,hostname
4       ,LoginName
5          ,ObjectName
6         
7          ,CASE
8                     WHEN EventClass = 46 THEN 'Created'
9                     WHEN EventClass = 47 THEN 'Dropped'
10                     WHEN EventClass = 164 THEN 'Altered'
11              END as EventClass
12       --,f.*
13FROM   sys.traces t
14       CROSS APPLY fn_trace_gettable(REVERSE(SUBSTRING(REVERSE(t.path),
15                                                       CHARINDEX('\', REVERSE(t.path)),
16                                                       260)
17                                             ) + N'log.trc', DEFAULT) f
18WHERE  t.is_default = 1
19       AND ObjectName like 'stored_proc_name'
20       AND EventClass IN (46, /*Object:Created*/
21                          47, /*Object:Dropped*/
22                          164 /*Object:Altered*/ )
23ORDER BY StartTime DESC
24