Sql to search who modified

SELECT DISTINCT
              StartTime
          ,hostname
       ,LoginName
          ,ObjectName
         
          ,CASE
                     WHEN EventClass = 46 THEN 'Created'
                     WHEN EventClass = 47 THEN 'Dropped'
                     WHEN EventClass = 164 THEN 'Altered'
              END as EventClass
       --,f.*
FROM   sys.traces t
       CROSS APPLY fn_trace_gettable(REVERSE(SUBSTRING(REVERSE(t.path),
                                                       CHARINDEX('\', REVERSE(t.path)),
                                                       260)
                                             ) + N'log.trc', DEFAULT) f
WHERE  t.is_default = 1
       AND ObjectName like 'stored_proc_name'
       AND EventClass IN (46, /*Object:Created*/
                          47, /*Object:Dropped*/
                          164 /*Object:Altered*/ )
ORDER BY StartTime DESC

Similar codes

-1 vote308 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote287 views1 answer
Like sql for second letter of the family name
SQL
0 vote267 views1 answer
Pl/sql loop example
SQL
15 votes284 views1 answer
Mysql int range
SQL
0 vote261 views1 answer
Sql examples from your work
SQL
0 vote285 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote293 views1 answer
Mssql disable foreign key constraint
SQL
0 vote259 views1 answer
Zsh: command not found: mysql mamp
SQL
3 votes269 views2 answers
Coalesce mysql
SQL
0 vote304 views1 answer
Alter domain sql
SQL